update form field from a pop-up 2nd form problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with an option box (1st form) tied to a table. When the option
box is clicked I open a second form where I would like the user to enter a
value for one of the fields in the table tied to the 1st form.

My problem is synchronizing the table record in the second form to the
correct record in the underlying table. It seems to update just the 1st
record in the table and not the current record that 1st form is working with.

How do I synch the edited record?
 
Al,
When you open the second form, use the Where portion of the OpenForm
argument to specify which record to open. Your 1st form should have a
unique identifying value (key field) that can be used in the OpenForm Where
to synch the records.
But... I don't know why you have the user enter a value on a 2nd form...
why not just use the option box you already have on the 1st form. That's
the field you're updating... why open another form to show possible
values... yout 1st optionbox should display the possible values.
hth
Al Camp
 
Thanks for the reply. My 1st form is getting too cluttered to have two more
fields for users to navigate through. Most users they will not be selecting
the option that opens the second form and gathers information for two more
database fields and form variables--so to keep the form cleaner I decided to
use another form.

I'm not following you on OpenForm Arguement. Below are my variables.

1st Form variables are: txtInputID which is also the DB index number.
optNatl which is the (Yes/No) option to
open 2nd form.
chrNatl is the DB variable I wish to
populate.
2nd Form variables are: txtInputID which is the record number from Form 1
(Forms!frmInput!txtInputID)
txtNatl which is the field I wish to
syncronize.

How would I code this?
 
Back
Top