Populate listbox on Dialog form

[Ipem]

Hello all,
First, let me explain the task I want to accomplish. In my tables I have a field called first serial. This is the first element of a serial number range associated with each record. Very rarely I have to ask the user to specify a certain serial number in that range. (The serial numbers can be generated easily from the first serial) This happens during the run of a macro, so I have to use a Fom opened with WindowMode:=acDialog.
The problem is that I have to populate a listbox with the generated serial numbers on that form. But I can't interact with a dialog form, since it stopos the running of the macro. I have tried to open it hidden, and change the modal property to true once the listbox have been populated, but this dosen't stop the macro to wait for user input.
Is it possibble to pass the first serial value to the form, and populate the listbox in one of the Form's opening events?

How can I do this?

 

[Mr. B]

You can pass a value to your form using the OpenArgs parameter of the OpenForm method.

Here is a link that may help understand this:
http://www.comboprojects.com/articles/accOpenArgs/accOpenArgs.html

 

[Ipem]

Thanks Mr. B, your reply have put me on the right path. I learn a new thing here every day.

 

[Mr. B]

You are quite welcome. Glad to help.