Double click to show matching details

B

Burt

i have a form based on 1 table.

the form has a tab control which has 2 pages. 1 page has fields from the
table. the other page has 2 embedded subforms based on queries made from the
same table.

let me explain in more depth

so........the table is a customer details table. The 1 tab in the form
shows some fields from that table( address, contact etc). The other tab has
1 embedded form which shows details of companys who havent been called. and
the other embedded form shows me companies who have been called.

what i want to be able to do is.......when i double click a companies record
in one of the embbeded forms, it takes me to the other tab and the matching
companies details.

thats kinda hard to explain ....

thanks in advace
 
S

Sprinks

Hi, Burt.

In the Form's DblClick Event Procedure:

Me!YourPageName.SetFocus

HTH
Sprinks
 
B

Burt

thanks for your prompt reply but i dont quite understand.

Do you mean the DblClick Event Procedure in ther mains form or the embedded
sub form?

and what does the ME! represent

do i use the actual page number or the caoption i have used?

sorry for being dense but could you explain in a bit more detail?
 
Top