Can you run a query on a form

[vince99]

is there a way to run a query on a form and let it return information regarding the record on the form that you are currently looking at an not all the data?




Thanks......

 

[JerryDennison]

What are you trying to accomplish? If there is additional information in the underlying recordset that you'd like to see why not add those fields to the form? Or do you want to see some type of related information specific to the current record? If so, then simply add that table to the underlying recordset and you'll have those fields available for display as well.

 

[gwinn7]

Yes, there are a couple of ways to do this. One is to create a subform with the master/child relationship between the main form and the subform. Another way is to place a Listbox control on the form and make the Rowsource property of the control show only records that are related to the current record unique identifier or primary key.

There is a built in wizard in Access you can run to build a subform. This wizard may be launched by placing the subform control on the main form. The subform will be a completely separate form but the control will be linked to the records from your main form to the subform, assuming they have a common field relationship.

That should give you some direction. I am sure you will reply if you get stuck.

Gary
gwinn7