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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filtering a form based on the values of a subform 0
Filtering a main form based on a sub-form 6
Linking Forms for new record 2
filtering a form based on a filter on an open form 2
Combo Box Filter 1
Excel Export Filtered Form Data To Excel 0
Search or filter form and subform 2
Filtering subforms 1

Back
Top