Forms and records

[salphonso]

Hello,

I am trying to create a form and I am not sure if it can do what I want it to do.

Basically, I have multiple customers. each customer can have more than 1 record. So, if I pull up a customer i want it to show all the records associated with that customer. then from that point i want to be able to click so-and-so record to view more details about each. Is this possible?

thanks,
Scott

 

[ajetrumpet]

Yes, of course it is. How far have you gotten on your own?

 

[gemma-the-husky]

have a form for the customers

have another form for the lnked records eg invoices

put the second form ON TO the first form. Access will ask you about how the two forms are linked

form/subform - job done - all links automatic, no code at all

 

[salphonso]

I should have explained more in my original post. The data is being pulled from 1 table. Basically, if i goto the customer lookup form and key in a last name and find my customer, when i hit the button to go further it load up the form that should show me the customer info and list out the records from the table that have to do with this customer. For example, if it were a table for tracking invoices it would list out all the invoice numbers associated with that customer. The problem I am having is, I can't figure out how to make it where if I click on (i.e Invoice 234) to bring up another form that will be the details of that invoice.

I wish i could let you all see the database to see what i am trying to do but it is confidential information.

 

[ajetrumpet]

The problem I am having is, I can't figure out how to make it where if I click on (i.e Invoice 234) to bring up another form that will be the details of that invoice.

I think something like this is probably very similar to what you want...

Is it?

 

[salphonso]

Exactly what I was looking for. Had to make some minor additions. Thanks a ton trumpet, your a life saver.

 

[ajetrumpet]

sure. good luck.