Subform

[rhernand]

I have one table with electrical equipment, tbl_equip. This table contains data like Serial Num, Company Num, Location, etc. I have a form, frm_search, based on a search query that I can enter the first number of the Serial Num and it will list all equipment that start with that number.

I double click on the one I need and display another form, frm_data, with all the data for that equipment. However, if that is not the one I wanted, I have to close this form, frm_data and search again.

How can I display the frm_data form on top of the frm_search form, in order to choose another equipment and view its data without having to close and open the forms.

I tried to create a subform based on the frm_data form and drop it on the frm_search DETAIL section. However, it changed the frm_search form CONTINOUS to SINGLE and I lost the equipment list on the frm_search form. Did I need to drop it else where? Or how can I accomplish this?

 

[theprez]

The first form should display enough information so that you Know you have the correct record. I would suggest adding more fields/info in the results of your search to make it easier to select the correct record.

Another aproach is to have a list box that has your search criteria on the same form you display your detail record. As the user clicks on a record in the list box, make the form display the detail records (frm_data). You would use the Click Event on the search list box and have code that does

Docmd.openform "new form",,, "serial no = me.Listbox"

Your search must have the fields that uniquely identify each piece of equipment. It may be a combination of CompanyName and Serial Number.

 

[rhernand]

Sub Form

I shall try it.

Thanks

The first form should display enough information so that you Know you have the correct record. I would suggest adding more fields/info in the results of your search to make it easier to select the correct record.

Another aproach is to have a list box that has your search criteria on the same form you display your detail record. As the user clicks on a record in the list box, make the form display the detail records (frm_data). You would use the Click Event on the search list box and have code that does

Docmd.openform "new form",,, "serial no = me.Listbox"

Your search must have the fields that uniquely identify each piece of equipment. It may be a combination of CompanyName and Serial Number.