Recent content by lamisamuel

this forum has answered many of my questions already before I registered today, such a great and helpful committee here:) thank you, Pat!

no no, I am just trying to modify a record by its ID into another popup form, no other insertions whatsoever. now everything is working as expected after arnelgp's proposed solution. thanks everyone for your feedback and your input on the matter.

wow. it worked :') I am so HAPPY. Thanks for making my day, arnelgp! now I got what you meant in your former comment, " just immediately kill the timer (Me.TimerInterval = 0), when you enter the timer event" a huge THANK YOU again!

sorry for any inconvenience. I just want to have some tables that I insert some data into manually, then retrieve such data dynamically in code whatever the used form is. I used similar code to perform other functions and it worked like a charm. this is just weird for me and I am not too good...

query only returns one row of two columns, i try to get the second column value and set it to MyCombo as it's default value to display on load

I tried this and I get the same error. Private Sub Form_Load() Me.TimerInterval = 3000 Call getSetRefNo End Sub Private Sub Form_Timer() Me.TimerInterval = 0 End Sub why it's not working properly? values are validated and everything's fine except defining the Combobox display...

can I use the form.timer event to delay the function execution until form is fully loaded?

it's not a subform, but this form is opened as popup & modal after clicking a textbox on a previous form before it, to open it where id=id

thank you for such quick response! may I ask how? I am not too good with VBA and it gets confusing really fast. thanks in advance.

I am trying to make a module to pass a single result of a query into a Combobox to be populated/displayed immediately on Form_Load event, but I keep getting the following error: Run-time error '2465' "Microsoft Access can't find the field 'MyCombo' referred to in your expression" Query result is...