Subform Requery

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lrollins - 31 Jan 2007 15:30 GMT

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

--
lrollins

Reply to this Message

Klatuu - 31 Jan 2007 18:03 GMT

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).

Signature

Dave Hargis, Microsoft Access MVP

> I have a mainform (frmDrawings) and a subform (subfrmLastDwg). They are
> linked. This will be a multi-user database that has been split. What I
[quoted text clipped - 10 lines]
>
> Lori

Reply to this Message