Macro Question

[k209310]

this is probably stupidly simple to answer but i have function in which requires the user to enter a number. The number is then used to retireve data from access.

I have a check to see if the data entered is correct. this works fine but from the point that the message box alterts the user of this problem and i need to somehow get the original inputbox to be redisplayed to allow the process to restart.

im new to vb so please have patience.

 

[Fizzio]

It looks like the values you want the user to enter are already available in access (ie stored in a table). A way to limit possible entries is to use a pop-up form with a combo (with limit to list set to yes) and the rowsource set to obtain the list of numbers. You can then refer to this combo as a parameter in your query/form/report. Is this helpful?
(ps Cold up here isn't it?)

 

[k209310]

A combo box might be too small for what i need. The database is to hold thousands of entris eventually.

What i have works fine its just that when the wrong code is entered i would like to give the user the option to reenter the code and not have to click the command button again to call up the function.


And yes its bloody horrible. it hasnt stopped raining for about a day. its a typical depressing monday today. Do you know if the sun has risen this morning cause we cant tell?

 

[Rich]

Re-set the focus back to the input box if no records are returned