Several Topics in One

[TeeSee]

An input form with several bound fields, two tables with referential
integrity invoked. I fill in the fields in the form and when leaving
the last field ...... if the [ItemCode] value in the first field is
not in the [ItemCode] master table Access tells me that. I open a
second form and add the item to the master table. At this time all the
input data is sitting in their respective fields and I still can't
force the data into my transaction table.
1) Am I better to write NotInList code in the AfterUpdate event of the
[ItemCode] text box (that's the first field) rather than input ALL the
data before getting halted?
2) After I close the form that adds the item to the master file how
can I requery, what do I requery and from where do I requery?

Best practice suggestions would be appreciated.

Thanks to all as usual.

 

[strive4peace]

Hi TeeSee (what is your name?)

each form/subform should be based on just one table. You should not try
to add a record to 2 tables at one time that have a parent/child
relationship.

read this and pay close attention to the secion on mainform/subform:

Access Basics (on Allen Browne's site)
http://www.allenbrowne.com/casu-22.html
8-part free tutorial that covers essentials in Access

Allen has a wealth of information on his site; after you get to the
bottom of this link, click on 'Index of Tips'

Warm Regards,
Crystal

*
have an awesome day
*