Database Problems

[gvloenen]

I am building a form that has information that fills in from an access database.

I want to be able to use the same database to fill in several identical fields. For example: I have to select 4 people and all their info and put it into the form. I do this by selecting their last name from 4 separate combo boxes. But how do i separate the info to prevent person ones info from going into person 2's info fields...

I would like to use the same database so i can update and still maintain a master

Any suggestions??

Thanks,
Greg

[Dököll]

I am building a form that has information that fills in from an access database.

I want to be able to use the same database to fill in several identical fields. For example: I have to select 4 people and all their info and put it into the form. I do this by selecting their last name from 4 separate combo boxes. But how do i separate the info to prevent person ones info from going into person 2's info fields...

I would like to use the same database so i can update and still maintain a master

Any suggestions??

Thanks,
Greg

Hey Greg! Can you give a little more? It sounds like you know what you are doing already. Are you getting info from different tables? If you are already building an existing access database, you can write a query that feeds into the form (i.e. data from table, to query, to form). Get in your table, add an ID for each user, make the ID field the primary key. Grab unique instances of each user from a query, feed into your form. Make the ID field, on your form, in your "Group Header", get all data fields in there. Good luck by the way, a form through access can be a pain.

Dököll

[Killer42]

Which VB are we dealing with here, though?

[gvloenen]

Which VB are we dealing with here, though?

I am using VB 2005 Express

Thanks

[gvloenen]

Hey Greg! Can you give a little more? It sounds like you know what you are doing already. Are you getting info from different tables? If you are already building an existing access database, you can write a query that feeds into the form (i.e. data from table, to query, to form). Get in your table, add an ID for each user, make the ID field the primary key. Grab unique instances of each user from a query, feed into your form. Make the ID field, on your form, in your "Group Header", get all data fields in there. Good luck by the way, a form through access can be a pain.

Dököll

What I am trying to do is to is make a program that i can put passenger info into for a buisness. (just a fun project, not serious). SO i want to be able to select their name from a combo box and have their info appear. Also I would like to be able to add passengers.

I have made an access database with the appropriate fields but the problem is that when i select a name in combobox1, the info will fill into textboxes that i don't want them to.

I need to separate how a text box will receive the info from the database.

I'm very new at this but If you don't think access is the best way, I am open for suggestions.. I don't want to have separate tables for each passenger because I would like a master list. I am also unsure what type of query i should be using to separate these. Can you give me a sample code??

Thanks for you help
GREG