afterupdate question

[jarheadjim]

i have a combo box that pulls information from a query. I want to populate 4 other fields with the appropriate columns after update. I just haven't figured out the code yet I have the columncount & width property figured out, I just don't quite understand how to get the other fields to pick up the appropriate data. Any advice?

 

[Adrianna]

Seems pretty simple...do you have a raw barebones version that you could post?

I guess I'm not understanding why you are not able to use the autofill feature of your combobox?

DO you have special constraints that are preventing it?

PS....is it just a matter of needing to REFRESH the form?

 

[jarheadjim]

The query has these fields [MarineName], [MarineRank], [MarineDutySection], [MarineSSN] and [MarineShop]. Combobox is [Name], and it's source is [MarineName]. I want other fields in my form to fill in the appropriate information based on what name is selected. I used the following code:

Private Sub Name_AfterUpdate()
[Rank] = [Name].Column(3)
End Sub

but it tells me "compile error, invalid qualifier" and highlights [name] in the debugger.

<edit>The primary key is column(1), which is why rank is third.

 

[Jerry Stoner]

Part of your problem(maybe not all) is that Name is a reserved word in access. Change your combo name to cboName and try again.

 

[jarheadjim]

Jerry, you are officially my hero! I should have thought of that.