Drop box pick auto filling in other values(2003)

[Ternick]

I am trying to make a Per-diem tracking program, and I don't know alot about access. I am trying to get it so when I select the county from a drop down box it fills in the meal and lodging alotments. I have the drop down box there, and on another form the County list with meal and lodging alotments.



Also I am trying to get this program to do other things so if anyone knows a website that could help i'd be happy for it. This is for Access 2003

[Missinglinq]

Here's a step-by-step; you'll have to replace all Field names with your actual names:

Place a Combobox on your Form. When the Wizard comes up

1. Select "I want combobox to look up values in a table/query"
2. Select your Table or Query
3. Click to move County to right hand box
4. Click to move MealAllotments to right hand box
5. Click to move LodgingAllotments to right hand box
6. Sort by County field
7. Select "Remember Value for Later Use"
8. Chose a caption for label (if desired)
9. Click on Finish

Now, assuming that the Fields, in the Combobox, reading from Left-to-Right are

County | MealAllotments | LodgingAllotments

in the AfterUpdate event for your Combobox use this code:

Private Sub YourComboBoxName_AfterUpdate()
  Me.County = Me.YourComboBoxName.Column(0)
  Me.MealAllotments = Me.YourComboBoxName.Column(1)
  Me.LodgingAllotments = Me.YourComboBoxName.Column(2)
End Sub

and Bob's your uncle! Notice that the Column Index is Zero-based.

Linq ;0)>

[Ternick]

First thank you for the help, but it isn't working right. I fallowed your steps and when I go to the View option to test it, it comes up saying Macro is not their or new and not saved. I have tryed with the index base as you did, and how it is in the table I have the information in and does the same thing.

[Ternick]

Ok fixed that problem, but now it comes up saying the Value I have listed for the meal alotment box and what is getting put in don't match, but I have double checked and they are both set for Currency

Fixed