Make all records on a form associate with a querie

[weircolin]

Hi There

Is there away to change the control sources of all the items on a form
use the same querie rather than having to change each of them
individually?

Colin

 

[Allen Browne]

Is there away to change the control sources of all the items on a
form use the same querie rather than having to change each of
them individually?

No.

You can alias the field names in a query (so they are consistent with the
form.)

You can use VBA code to loop through the controls if their names have some
consistency.

But before you do any of that, you might consider whether you have a good
relational design if you need to constantly change your field names.

 

[fredg]

Hi There

Is there away to change the control sources of all the items on a form
use the same querie rather than having to change each of them
individually?

Colin

Not sure I understand the question.
You currently have a form bound to 'TableA', with fields bound to
LastName, FirstName, and Phone.

You wish to change the form's record source to a query (QueryB) and
then change each control's control source to the fields of the query?

As long as the Query returns fields with the exact same field names,
all you need do is change the form's rowsource from TableA to QueryB.