Help!  I cannot see the problem.  My forms don't link.
Parent form's record source is tbl2PO, InvNum PK, ClientID is in the table.
Subforms's record source is tbl1ScheduledPO, ClientID PK.
The intent of the form is to update/add/edit tbl2PO while displaying (only)

Hi. I would like transform/convert a comma into dot.
I think that something as Keydown = , then . somethign like that.
Is it possible?
Regards,

I've got this annoying thing where the reference to formfields are not
recognised in the VBA module if I refer to them by their name only. I
need to include the reference to the form. Is there a workaround,
would save me a lot of typing?

In my church membership database that I am working on, I have the form
similar to the MS Access database sample Address data base.
It has tab control, for tab 1 is address and for tab 2 there we can see all
the members of the household.

Whenever I try to refer to an option group or option button on a form,
whether in a form or macro, the form becomes corrupt and I can no longer view
or modify the design. It's as if the form is no longer there.
I want to add code based on the option selected by the user. The ...

My form's users enter three numbers (between 1 and 5) in Columns A, B, and C.
If all three numbers are (for example) "4" then the table's "Column D" must
contain the number 4.  But if the numbers differ, then the lowest one goes in
column D.

       I'm still stuck on this.  I have a multiselect listbox in Access 2002.  
I want to force the first record to be selected from VB after the listbox is
requeried.  As I understand it, the value property always reads Null in this
case.  Trying to set it doesn't work, so I assume ...

Help! I'm new at access, and have just finished creating a form in design
view but now can't work out how to begin entering my data as the 'new record'
button isn't highlighted. Any suggestions why? Thanks

I have a form in Access 2003.  The form contains a combo box.  When the user
selects a record from the combo box, I want to have up to 6 images load onto
a 2nd tab of the form.  The image files are in a specific folder related to
the record they select.  In other words, if they ...

I have an Access 2000 application that has been on the market for about 5
years with hundreds of copies being used with no problems.
Yesterday I tested a new setup file, created to be Vista ocmpatible, and I
noticed that on the startup form an embedded image appears shrunk and

I tried this code, found in discussion group, on the OnLoad event of my
subform and I get message "No Parent".  The desired result is that subform
does not allow edits.  What am I missing?  Am using Access 2000.
Thanks, jim

Is there a way to change the color of the Msgbox dialog box?
I would like to differentiate between two messages.
Thanks
Abe

I am looking to have a form, With 1 combo boxes (telephone), and the
rest text boxes.
I want to be able to select a telephone number and have the other 2
boxes shows the associated firstname and last name

I have a data form that the users use to input data. Once all the fields are
filled in and "Enter" is hit. I would like to have a pop-up message box
appear confirming that the data is successfully entered in the Db as
acknowledgement. Could some one guide me how I can go about ...

I have an invoice form on which I want the next number to be allocated (using
DMax on the InvNo in tblInvoices) but only upon saving the form.
At the moment it is allocated upon opening the form but that's causing a
problem if the user aborts for any reason - it still uses up a ...