Search by field

[vCallNSPF]

I have a form for Pagers that has two search functions:

The first is a 'Search by Serial No.', which allows me to enter in a serial number and it comes up with that pager. It works fine and I have no problem with it.

The other search is 'Search by Facility', where there may be more than one Pager in each of my companies buildings. This is what I'm having a problem with.

The way my form is set out is with a data entry form up the top, and a sub-form down the bottom (that looks like a table) where I want to have other Pagers from the same facility displayed. How do I get the other Pagers from the same facility to appear in the sub-form?

[HiTechCoach]

Try setting the Master/Child linking field properties for the sub form control.

You will probably need to use the after update event of the control for the Facility to requery the sub form.

[vCallNSPF]

Try setting the Master/Child linking field properties for the sub form control.

You will probably need to use the after update event of the control for the Facility to requery the sub form.

Hey,

I've set the master/child linking field, how do I use the after update event to requery?

EDIT: It DOES actually show all the results for a facility BUT I have to press the arrows down the bottom of the subform, is there any way to stack them there like a table?

[HiTechCoach]

I am assuming you are using a comb box to validate the user input

To requery the sub form from the combo box place this code in the After Update event:

 
Me.YouSubFormNameHere.form.Requery

Note: substitute YouSubFormNameHere with your actual sub form's control name.


Change the sub form to continuous view to see all the records in a list.

[vCallNSPF]

Change the sub form to continuous view to see all the records in a list.

this is just what i needed Solved

[HiTechCoach]

this is just what i needed Solved

Glad that worked for you.