How to filter form?

Gigantcus

New member
Local time
Today, 07:17
Joined
Jan 11, 2015
Messages
7
Hello! I'm new in Access and don't know a lot bu I learn quick.. I'm stuck with one thing. I'm creating a database about Vets and I need to make a button on my menu form that will open something like message box that will allow me to type in something (in my case Customer ID) which will then apply the filter on the customer form and allow me to do edits. I have only done the macro that will open the customer form but can't figure out how to do the filter part. So anyone have any idea how I could do this? Hope this makes sense!
 
Use vba, not macro

Use doCmd.OpenForm to open your form. Put the custID as the OpenForm filter.

You can use InputBox to get the re weuired custID
 
More on this:
Try to NOT use an InputBox control.

In the main form create a ComboBox or a ListBox from where select the Customer and use this information in order to open the second form.

or

Use a Form and a Subform.
 

Users who are viewing this thread

Back
Top Bottom