When a command button is clicked, it open a smaller form in 'dialogue' mode. What I nned to do is have the value of a field on the main form appear in a text box on the smaller form as soon as it is opened, which is bound to a different table. (There is a relationship between the two tables via this field.

I am trying the 'Current' event procedure, but I am getting into a mess !Can anybody help ?

Many thanks.

I HAVE WORKED IT OUT ! NO NEED TO REPLY TO THIS TOPIC !!! MANY THANKS