Problem with a Form

[Bill Pugh]

Hi All:

I'm new to the forum. What I'm having problems with is a forum with combo-boxes. What I need is a way to reset the form "like a F9" so one table will not be locked. I've tried all the stuff under "Options" without any luck. I do know, that all I have to do is hit F9 each time and the form will work without giving me the error.

The database engine could not lock table ' ' because it is already in use by another person or process.

Thanks for any help
Bill Pugh

 

[pono1]

Bill,

Hard to tell exactly what is happening and why and when it happens on your form but the following code is more or less equivalent to pressing the F9 key.

	Forms!YourFormName.recalc

You'll want to run this before the event that triggers the error message -- may or may not be an OK work-around...

Regards,
Tim

 

[Bill Pugh]

Thanks Tim

That worked! Much nicer reply from you than I got from my other post..