Combo Box that doesn't cause Edits??

[office_guru]

I have a form that I'd like to use for 'reviewing/report' purposes. It's a main form with a combo box of company names, with a subform of all the company information. When you use the combo box to select a company, all the cooresponding data loads in the sub-form - which is totally what I want. The problem is that it's trying to over-write the first record which I don't want it to do.

Further explanation -
Have a company table with 23 companies, and the company name is the primary key. I want to be able to use the combo box to pull a company's name to show all information without then trying to close out of the form or view next record without it saying I'm creating a duplicate entry - goes back to the combo box is editting my data when i want to just view the data. I have tried using a query based on the table but the same thing happens.

Can someone please explain if what I'm trying to do is a. possible b. how to.

Much appreciated!

 

[Pat Hartman]

When you use a combo to find records, it needs to be unbound. Therefore, if the form is also used for data entery, there may be two controls for the same data.

 

[Garn77]

Office guru,

I'm trying to produce the same thing, a combo box that can be used to select a refernce number and subsequently 3 other text boxes will autofill (2 of which are in a subform), please can you run through what you did so I can get this right??

Thanks

 

[Pat Hartman]

Garn, your problem is different. Download my Populate fields with reference data example.

 

[Garn77]

Pat

I put in your formula on my unbound fields and it still wont work Aggghhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh!!!

I need help badly, what can you suggest i look at, I used the cboCodeID formula, se

Selecting from a combo box with the aim to fill in another combo box and 2 text boxes within a subform. When the data is entered it doesnt do a autofill, it doesnt do anything. Help me please help!!!!

Cheers

 

[office_guru]

Still confused

K I need some clarification still - my combo box is now unbound but I can't establish a relationship between an unbound form with a bound form. FYI I still have the subform. Even if I put everything on the same form, how am I linking the unbound combo box with all the other fields to pull up there data?

Hope I'm making sense because my brain is slowly going to mush. at least it's friday!

 

[office_guru]

Problem Solved

For anyone with the same problem as me I couldn't believe how easy the solution was and how slow I was in figuring it out.

I got rid of the subform and had all my fields on the same form, I added a combo box and used the wizard and selected the third option for the wizard to "Find a record on form based on the value selected in my combo box". As Pat advised the combo box is unbound however the form needs to be bound along with fields that coorelate to that table.

Sorry if I've pointed out the obvious for many but hopefully this can help someone that was having as many problems as I did for something so amazingly simplistic.