1 form 2 queries

[Dummy]

hi,

i have a Main form with 2 command buttons on it, cmdOld & cmdCurrent

can i assign in One Form's Record Source 2 Queries? not at the same time for sure...let me give the correct figure

i have a Main form with 2 command buttons on it, cmdOld & cmdCurrent

when i click cmdOld i will load a Form with record source qry_old,
when i click cmdCurrent i will load the same Form with record source qry_Current,

is this possible, if yes what is the coding of it please

thank you

 

[Mile-O]

Send a value to the form's OpenArgs property by using the OpenForm method.

In the form's OnOpen event, check the OpenArgs property and set the RecordSource it to the relevant query.

The words in bold are terms to search for on this forum and in the Access help files.