Double click to show matching details

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi, Burt.

In the Form's DblClick Event Procedure:

Me!YourPageName.SetFocus

HTH
Sprinks
 
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?
 
Back
Top