hazlehurstga
Programmer
The following MSAccess 2000 VBA coding atempts to get input from the user by opening a form so the user can select from a combo list:
The problem with the above coding is that it goes into the loop immediately after opening the form. The user is not given an opportunity to make a selection. NOTE: There is coding within the form itself that sets the global variable "ProcessingForm" to false after the user makes his selection.
What I am attempting to accomplish is to take advantage of the features available in a form to input a user's selection vice using the very limited features of the InputBox function. Also, the user will need to select from a list of options available, and, I don't believe the InputBox function will let the user choose from a list of options.
Can anyone help? Thanks
Code:
ProcessingForm = True
DoCmd.OpenForm "ASSIGN CTPOC", , , , , acDialog
Set LoadCTPOC = Forms("ASSIGN CTPOC")
LoadCTPOC.Visible = True
Do While ProcessingForm
Loop
The problem with the above coding is that it goes into the loop immediately after opening the form. The user is not given an opportunity to make a selection. NOTE: There is coding within the form itself that sets the global variable "ProcessingForm" to false after the user makes his selection.
What I am attempting to accomplish is to take advantage of the features available in a form to input a user's selection vice using the very limited features of the InputBox function. Also, the user will need to select from a list of options available, and, I don't believe the InputBox function will let the user choose from a list of options.
Can anyone help? Thanks