Form, popup form (1 Viewer)

[SantoR]

i have continuous form having a source as table A.
when i click a displayed field value from the table A in this form, a pop form is opened (by passing the Primary key) which displays all the details of that record from the same table A.

Now i have a one more button on this popup form , which opens a seond popup form , which allows user to select any other records (Primary Key) and see its details on first popup form.

main form ---->first popup form---->second popup form.
(all accessing same table.)

All works fine but when i select other primary key from second pop form and pass it to first popup form , it does not refer it , it refers to old primary key of main form only.


i believe, we cannot point at two different records in a table at same time ?

any solution or work around to this situation.

 

[burrina]

I would try a OnClickEvent Requery and see if that helps.

 

[spikepl]

pass it to first popup form

Do you pass it as I pass water? Or how exactly?

 

[vbaInet]

... displays all the details of that record from the same table A.

i believe, we cannot point at two different records in a table at same time ?

Sounds very much like a flawed design. Are you aware of the term, "normalisation"?

To move to a particular record, use the FindFirst method of the form's recordset.

 

[JHB]

..
Now i have a one more button on this popup form , which opens a seond popup form , which allows user to select any other records (Primary Key) and see its details on first popup form.
...

Why that second popup form, why not just select an other record in the main form?