Forms not working together well

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

Guest

I have a series of 3 forms. The first form is primarily data entry. The
person entering data makes the determination if the second form is necessary.
If the information requires the second form, the data entry person checks the
box stating the next form is necessary. I wrote the macro for the second form
to automatically open.

The two forms are linked via a control box I'll name "description". On the
second form, I'm doing a drop down menu to force the data entry person to
select from the list of "description" entered within any of the first forms.
Everything works well, except I can not get the content in the "description"
from form 1 to be available as a choice on form 2 until after I've finished
and closed form 1.

Any thoughts on how to get past this?
 
With the info you've given, I think you just need to do an Update or Refresh
on form1 before opening/creating subform2.
Probably the data you just entered in form1 has not updated to the table
yet, so a combo query based on that field would not show that new entry.

I'm a bit unsure why you're "linking" the 2 subforms by a text Decription
field. They usually should be linked via a unique identifier (key field) on
the main form. Sounds like you'll end up with duplicate Descriptions, and
cause subform records from other records to appear in your subform.
Maybe I misunderstood...
 
Back
Top