Recent content by labonte373

I am try to add a word writer form to my db. I keep getting runtime error 424 object required. Here is the code: Option Compare Database Private Sub cmdCreate_Click() ' Copy the text to a Word document Dim objWord As Word.Application ' Instantiate Word and a new document Set...

The cboNumber displays the car/serial number and the txtModel displays the model.

SELECT [CarNumber], [Car/Serial Number], [Model], [Type] FROM [Car Numbers]; per your suggestion I added 4 columns with widths of 1";0;0;0; Private Sub txtModel_Click() Me.txtModel = Me.cboNumber.Column(1) End Sub

I got it fixed on my own. Thanks for all your help and patience!

Ok. I got that to work ok but the code that I typed into the txtModel does nothing. me.txtModel = cboNumber.column(2) I appreciate your help with this.

When I changed the row source, the only things that show in the cbo is the model and type. Not sure what happened.

Model is listed in the CarNumbers table as well as type and car/serial number.

My db is way too large to post. I will post the most info I can. RowSource type = Table/Query, SELECT [Car Numbers].[Car/Serial Number] FROM [Car Numbers];

Well I tried that and it didn't work either. I'm not sure how to add anything else to the row source as I've got the car/serial numbers joined there. Thanks

Here is what I've done so far but it does not work Private Sub cboNumber_AfterUpdate() If cboNumber <= 30 Then txtModel = "T-FLEET" ElseIf cboNumber > 30 And cboNumber <= 55 Then txtModel = "CARRYALL" ElseIf cboNumber > 55 And cboNumber <= 86 Then txtModel =...

RuralGuy, Thanks for the response. I'm new to Access and VBA. I really do not understand what I need to do. I have a cboNumber box that has the car number and serial number ( [1] PRO730-562147). I want to be able to click in the txtModel box and have the correct model (T-FLEET) fill in...

:confused: Hi. I'm trying to code a textbox in VBA to look at a combo box for the data. I have a combo box that lists car numbers and serial numbers. I want the user to be able to click in the Model text box and have the correct Model fill in. I've tried an If..Then..ElseIf clause, If..Then, and...