Form Automation

[sparky01]

I need to be able to design a form that will allow me to choose from a Combo box a field from a table and place all other related fields in the form so that I can store this information into another table. I will try to explain more I am work on a database where my client has given me a list of client information. Things like the clients name, job location, how much the client pays. What I need to do is be able to choose from a Combo box the location of the Job, and have all the information mention above to fill in the form so the user dosen't have so much data entry.

Can this be done easily and how,

Thanks in advance

 

[PHV]

Take a look in the FAQ area of this forum. There is a section devoted to combo.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[TheAceMan1]

How are ya sparky01 . . . . .

If there's a [blue]One to Many Relationship[/blue] between the tables, you can make an [blue]AutoLookUp Query[/blue] that inserts the data from the Combo. If not a [blue]One to Many Relationship[/blue], then you'll have to do it in VBA.

Is there a [blue]One to Many Relationship[/blue] between the tables?

What are the the names of the tables?

What are the [blue]PK[/blue] & [blue]FK[/blue] names of the tables?

What is the actual name of the [blue]Location[/blue] field?

See Ya! . . . . . .

 

[sparky01]

Yes there is a one to many relationship ther PK is a ticket number that is generated from the job. this is given to the client when the they go to the job site the actual name of the location field is strclientlocation this the lcoation of the client site the driver picks up the load to deliver and drop off each haul is listed togather this is because of a perdetermined amount of mile that each haul is going to take. If you need more info let me know.

David

 

[TheAceMan1]

sparky01 . . . . Sorry for getting back so late.

Forgive me, but if you read my previous post again, you'll see I'm specifically asking for [blue]Names![/blue].

So what are they? (Can help you better with this info)

See Ya! . . . . . .