L
lazerleo
I have a form called:
frmAssociated_Lots
This form has two fields:
fldEventID - Automatically entered
fldAssociatedLot - Entered by user
The user can add many associated lots for one event. I have a button
which saves the record and empties the txtbox so they can add
another..and so on. When the user adds a new associated lot i want it
to immediatly appear in a subform with some extra details from a lot
table i.e. Lot Discription.
Should i create a query to search the lot table for whats enterd in
fldAssociatedLot and then create a form for this query and add it as a
subform?
Im new to access so any guidance would be much appreciated. Im just not
sure which is the best path to take or if im going about it all wrong.
Thanks in advance
Leo
frmAssociated_Lots
This form has two fields:
fldEventID - Automatically entered
fldAssociatedLot - Entered by user
The user can add many associated lots for one event. I have a button
which saves the record and empties the txtbox so they can add
another..and so on. When the user adds a new associated lot i want it
to immediatly appear in a subform with some extra details from a lot
table i.e. Lot Discription.
Should i create a query to search the lot table for whats enterd in
fldAssociatedLot and then create a form for this query and add it as a
subform?
Im new to access so any guidance would be much appreciated. Im just not
sure which is the best path to take or if im going about it all wrong.
Thanks in advance
Leo