Search results

Thank you TJ! That did it! Private Sub ProductIDCombo_AfterUpdate() Make = DLookup("Make", "ProductList", "ProductID= '" & me.ProductIDCombo & "'") Model = DLookup("Model", "ProductList", "ProductID= '" & me.ProductIDCombo & "'") AssetType = DLookup("AssetType", "ProductList", "ProductID= '" &...

The second option where the autofill information is saved to my table is precisely what I'm trying to do. I setup the View Source my Combo box SELECT [ProductID], [Make], [Model], [AssetType] FROM ProductList; Then I setup the After Update event on my ProductIDCombo box to populate the Make...

I updated my code using the following example - DLookup("FieldName" , "TableName" , "Criteria= 'string'") Here is my code - Private Sub ProductIDCombo_AfterUpdate() Make = DLookup("Make", "ProductList", "ProductID= 'ProductIDCombo'") End Sub I am no longer getting an error, but...

Thanks for the quick reply. By text syntax do you mean the string syntax? I am a little new to VB scripting for Access. Thank you for your patience. Jim

Greetings, I have an asset database I am designing to manage our computer inventory and assets. I am trying to get a DLookup to work with one of my forms that will auto-populate some of the fields depending on what is entered in to the ProductID field. For instance, Make, Model, Asset type...

Creating an access database to manage our computer assets. I've been following for a while, thought I would finally join and make a contributions or create problems :) Jim