requery after entry into field?

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

Guest

I have a form (frmEstimPlanList) based on a query (qryEstimPlanList) which
pulls together fields from 2 tables: tblProject and tblBid (tblBid is on the
Many side of a One-To-Many relationship).

When entering into frmEstimPlanList, after entering into the ProjectName
field (from tblProject), it does not allow entry into any of the fields that
originate in tblBid. The user needs to click out of that record, and back in
for it to allow entry into the remainder of the fields. I am assuming that
doing this allows it to requery.

Is there an expression or code that I can perhaps enter into the AfterUpdate
event that would fix this? Thank you in advance for any feedback!
 
Kevin

If your tables have a 1-many relationship, a standard way of handling that
in your forms is to use a main form (for the "1" side data), and a subform
(for the "many" side data).
 
Could this be applied in a subdatasheet view? So the many side would be
opened with the "+" symbol? Thanks again!
 
Kevin

If you are considering using the tables for your data entry, you'll find a
lot of folks responding here who will tell you to "step away from the
keyboard!"

Tables store data, forms display it. If you don't use forms, you lose out
on the rich event model Access provides.
 
Back
Top