Form and subform 1

[Bill0722]

I an pretty new to all this and a bit confused, so any help would be great. I have two tables, a customer table, with ID, Name, address, etc. and a work performed table, with task ID, task, etc. I want to create a Form that I can select the customer ID with a lookup table, and then have all the details for that record appear, with a subform for the work performed. I can make all this work, except for the displaying of the initial record. I hope this makes sense.

 

[ssatech]

Take a look at the "Service call management database" sample at:

http://office.microsoft.com/en-gb/templates/TC010184671033.aspx?CategoryID=CT011366681033

Just use the combox wizard to creat a search for Customerid and all related work to a customer...

 

[ChanceD2]

Bill,

Did you get the answer you are looking for?

There are 2 different ways of going about this.

1. If you are truly only showing the "Customer ID" on the form, and the sub-form is displaying the information based on the selected Customer ID, then you might consider using a listbox to display all of the Customer ID's and then using the main form to display the selected record. This eliminates the sub-form (which is slower, takes more room in your database and can be tricky). Let me know if you need more info on how to get this to work.

2. Use the main form to select the record and use a sub-form to display the selected record. (This is what you suggested origionally). The way you do this is to base the recordset of your subform on the main form. Then when you select a record in the main form, you put in code to requery the sub-form. Again, let me know if you need more info on how to get this to work.

I guess what you need to do is decide exactly what you want to do, or explain exactly what you are trying to do....

let me know..

C-D2

 

[Bill0722]

Thanks alot to both of you. Actually the Service Call Management template is perfect for my use. Again, thanks.

Bill