Adding Records in a filtered form

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

Guest

Is there a way to add records in a filtered form? I want to open a form to
let the user add orders that are restricted to the current client. I don't
want to use sub-forms because there is too much information that needs to be
entered to fit into a sub-form. Maybe fill in the clientID number with VB?
I'm not sure.

Thanks
 
Assuming you have a form where they choose the client (or if they already
have that form open to a specific client, add a command button and in the
click event...

If Me.Dirty then Me.Dirty = False
DoCmd.OpenForm "Name of Order Form",,,"ClientID = " & Me!ClientID
 
Back
Top