Easy one

[sigmar]

This can't be difficult.
How can I refer to a table field in VBA to dinamically change the controlSource of a form control??

I mean changing the source to the same field, but in a different table. For example:
Changing Source from Table1.Name to Table2.Name

[This message has been edited by sigmar (edited 07-02-2001).]

 

[Robert Saye]

This is from VBA help (You get VBA help by opening help from a module window).:

ControlSource Property Example

The following example sets the ControlSource property for a text box named AddressPart to a field named City:

Forms!Customers!AddressPart.ControlSource = "City"
The next example sets the ControlSource property for a text box named Expected to the expression =Date() + 7.

Me!Expected.ControlSource = "=Date() + 7"

Robert

 

[sigmar]

I've already read that help, but what I want to do is refer to one of the tables in my database, not only to the field. That's because some tables have same field names.
Thanks anyway for your help.