Fill Form to Update Record from Combobox selection

[ChrisLayfield]

I am a total noob to Access (this is day 1), though I did teach myself VBA in Excel.

I am having a lot of trouble with this and I am not sure if it is my thought approach or that I am not comfortably finding the automation in 2007 fun. I am trying to make a simple employee training dB and want to have a form to allow record updates. The user would select either the last name or employee ID from one of two combo boxes and this would query (I read this many times) the rest of the data to the form. The user could then update any of the data and it would save back into the dB.

Anyone know of a code sample or something that could get me moving?

 

[boblarson]

Actually you can have your form which is bound to the table or a query to do the updates. Then in the form's HEADER you can add a combo box using the Wizard (if you have the form already bound to the table you should get 3 options on the wizard, the last which says Find a Record...etc.). Choose that and it should set it up for you.

You can then select the person from the list and it will go to that record.

 

[boblarson]

Oh, and by the way:

 

[ChrisLayfield]

Thank you for the welcome. So how much trouble am I in if I couldn't do what you suggested?

I have the table built with some made-up data. I used the create form to make the form with all of the data from the table. No problem. I added the combobox using the wizard to the header, but the only option I had was to select the data to be included within the combobox, not link the other boxes to the selected item.

 

[boblarson]

I don't understand your question. If you use the wizard to build a combo box so that you can select the person, does that not go to the person? Are you saying that you didn't get the third option:

 

[ChrisLayfield]

Yes that worked, I don't know what I was doing wrong. Maybe google-eyed from tryign to do this all day.

I will move on from this to convert to VBA so I can learn more. Thank you very much Bob, you have been a tremendous help already. I am sucking up because I will have many more questions I am sure.

 

[boblarson]