Search results

Thanks Minti, i can't believe i didn't notice that for myself, it works perfectly now.

Hi arnelgp Its the 4th column i'm interested in retrieving the value from, but thank you all the same.

The field Names are correct as they have been copied and pasted. I can retrieve the Value by other means, by adding another combo box to lookup the Staff_Skill_level and the Staff_Skill_Level_Bonus in tblStaff_Skill_Level_Bonus based on the value stored in Column 3 of Combo39, and then write a...

It's a number

Hi Minty The value returned if i run debug.Print Forms!frmCustomer_Receipt!Combo39.Column(3) is 1 as expected. I have tried using both Me.Combo39.Column(3) and Forms!frmCustomer_Receipt!Combo39.Column(3). Both methods result in the same run-time error '2471': The expression you have entered as...

I'm relatively new to using VB in access and i have came across an issue using the DLookup function to retrieve a value in a table based on a value in a combo box. I am struggling to write my third argument correctly to retrieve the value in my combo box. The closest i can get to writing this...

Thank You, it Worked Perfectly!

I'm Very New To Using VB in Access and I've come across an issue of not being able to override the on load event. I'm in the process of creating a booking system where users must first create an account in a form (if no account exists already). I have written a few lines of code into the...