Subform Requery

[lrollins]

I have a mainform (frmDrawings) and a subform (subfrmLastDwg). They ar
linked. This will be a multi-user database that has been split. What
want to be able to do is this:

When a user enters a new drawing number, I want the subform t
immediately refresh or requery so that the number used will show in th
subform so that the next person knows what number to use.

The drawing number is generated by a code using dmax.

Someone please help me. I've been working on this for what seems lik
forever. Hope this makes sense.

Lor

 

[Klatuu]

Try using the subform's After Insert event to requery the subform. (In this
context I mean the form that is the source object of the subform control).