Linking Forms

[seanog2001]

hi,

ive got a stores form where u add stores to a database, i also have a history form which gives information about the stores history, i want to be able to link these forms.

Basically they are linked in the relationships via a store number, so when a user is scrolling through stores he can click on a command button which will bring up the history on that particluar store

Any help?

 

[jmrSudbury]

on click use the docmd.openform "StoreHistory",,,,,"StoreNumber=" & StoreNumber

I don't remember how many commas are needed, but that last bit should be in the filter section.

John M Reynolds

 

[RuralGuy]

The WhereCondition is the 4th argument in the OpenForm command.