passing a value between forms

[darcy]

F_addrecord has a certian item_code which i want to pass to F_colours , to assign colours and sizes to it.

Can anyone help me figure out how to just click on the link to F_Colours and have the item_code that it passes to.


thanks

 

[namliam]

have a search on OpenArgs either on the forum or in the access help....

This is the way to pass stuff from one form to another.

Regards & GL

 

[maxmangion]

to use openargs on form1 you should put:

DoCmd.OpenForm "formname" , , , , acFormAdd , acDialog , textboxname

then on the onOpen event of Form2 put the following:

if me.openargs <> "" then
me.textboxname = me.openargs
end if