Access Help

[dsealer]

Paul,
I apologize for being dense but I've been trying to follow what you've said. So I'm going to print your instructions and substitue my names in place of your field/combo names.

If your situation is that rare one where saving the related info is necessary, you'd use the same combo. In the textbox, instead of the formula as the control source, you'd list the field (GageID) in the Orders table (Calibration DC) where you wanted the phone number (GageID) saved. In the after update event of the combo, you'd have code like this to copy the value over:
Me.TextboxName = Me.ComboName.Column(2)
Me.Gage ID = Me.Gage Description.Column(1)
Maybe the problem is (besides my lack of understanding) the name. As I see the Text Box Name (Gage ID) and the Combo Name (Gage Description) they both have spaces between the first and second parts.


What did I do wrong and not understand?
Don.........

[dsealer]

Paul,
I apologize for being dense but I've been trying to follow what you've said. So I'm going to print your instructions and substitue my names in place of your field/combo names.

If your situation is that rare one where saving the related info is necessary, you'd use the same combo. In the textbox, instead of the formula as the control source, you'd list the field (GageID) in the Orders table (Calibration DC) where you wanted the phone number (GageID) saved. In the after update event of the combo, you'd have code like this to copy the value over:
Me.TextboxName = Me.ComboName.Column(2)
Me.Gage ID = Me.Gage Description.Column(1)
Maybe the problem is (besides my lack of understanding) the name. As I see the Text Box Name (Gage ID) and the Combo Name (Gage Description) they both have spaces between the first and second parts.
What did I do wrong and not understand?

[pbaldy]

The spaces cause problems, and I'd always advise against them. This works (Access tries to help with the spaces):

Private Sub Gage_Description_AfterUpdate()
  Me.Gage_ID = Me.Gage_Description.Column(1)
End Sub

[dsealer]

Thanks Paul. I thought the spaces might be part of the problem but I didn't know about the underscore. I seem to recall years back someone telling me about not using spaces.
You'll might be glad to know I figured out how to do the rest of the fields so I won't be bothering you with that!
Thanks very much for all your help and paitence with me and my constant questions. You have the patience of a saint. Hopefully you don't get many people like me.
Thanks again,
Don..........

[dsealer]

Still another question.
I'd like the field (calibrated By) in my form to look up the initials of people. Those initials can be found in a table called "All Inspectors". The data I want to look up is the first column in that table.
So I made the "Calibrated By" field in the form a combo and added this to the control source =[All Inspectors].[InspectorsInitials]
Needless to say it doesn't work. I've tried many variations of this but without success.
What would I need to add to make a drop down box in this field of my form?
Thanks again,
Don......

[pbaldy]

Happy to help Don. On the inspectors, I'm not sure what you're saying. The calibrated by control is a textbox, not a combo. You can change it by right clicking on it in design view and selecting Change To, but it's probably simpler to delete the textbox and use the combo wizard to add a combo. If you change the textbox, you have to set all the new properties, whereas the wizard will set them for you.