Form based on query result to open selected record

[Guest]

I have one master data table which a query uses to display results (table
format) in a form. Now what I would like to do is to select a given record in
the form and by clicking on a button open another form which displays all the
details for that record.

How can one go go about it?

Thanks
MSA

 

[Steve]

You need to revise your database and create a set of related normalized
tables from your master data table. You will then be able to create a
form/subform where you display a given record in the main form and display
its details in the subform. You will even be able to set up a Find Record
procedure to find the record you are looking for in the main form.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[StopThisAdvertising]

You need to revise your database and create a set of related normalized
tables from your master data table. You will then be able to create a
form/subform where you display a given record in the main form and display
its details in the subform. You will even be able to set up a Find Record
procedure to find the record you are looking for in the main form.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

--
You are *not* a resource at all !!
Tell us you will stop advertising here, or get lost for another year or so...
http://home.tiscali.nl/arracom/whoissteve.html

ArnoR

 

[jahoobob via AccessMonster.com]

You can put all the info from the table in a form and use a search combobox
(the third choice in teh combobox wizard. You can include all the fields you
want in the combo and when you select the record, the other info will
populate the form.

 

[Guest]

Thanks for the input - ok so I have now the combo box and its reading the
record numbers and also I can select the record (say 8). Now with a macro I
have been able to open the record detail form. The only problem is how to
pass the selection (i.e. 8) to the detail form so it loads the relevant info
for the record #8 in this newly open form.

Thanks for your assistance.

 

[jahoobob via AccessMonster.com]

I would use the same form to display the additional information. Each time
you select a new record from your combo lookup it will be displayed. Much
more efficient this way and much less complicated to deveolp. If you use a
second form, you will need to close or minimize it before you lookup anopther
record.

Thanks for the input - ok so I have now the combo box and its reading the
record numbers and also I can select the record (say 8). Now with a macro I
have been able to open the record detail form. The only problem is how to
pass the selection (i.e. 8) to the detail form so it loads the relevant info
for the record #8 in this newly open form.

Thanks for your assistance.

You can put all the info from the table in a form and use a search combobox
(the third choice in teh combobox wizard. You can include all the fields you

[quoted text clipped - 10 lines]