Error 2424 Object not found...

[Kevin_S]

Hi Everyone,

I have to post this because it is: (1) Driving me INSANE and (2) I can't for the life of me figure out what is going wrong so here goes....

I have an unbound form that, at runtime, is given a recordsource of 1 of 2 queries depending on the users selection on the previous form through the double-click event of a listbox with this snippet of code:

[Forms]![frmVac_Log].RecordSource = "qryVac_Log"

Simple enough and everything works great.

Now - what I want to do is hide or display a few controls on the form depending on a selection in the form with a simple If-Then-Else statement like this example:

If (This field) = 1 then
'Display this control
else
'Display that control
end if

Very, very simplified HOWEVER When I put this If-Then statement in ANY Event Procedure (On Open, Current, Activate, Load,etc...) It errors and gives this message:

Runtime Error '2424'
The expression you entered has a field, control, or property that Microsoft Access can't find

And it highlights the first line in the if-then code

Everything is spelled correctly and the references are set right - no spelling errors or nothing...

Anyone have any ideas why this is happening?

Thanks,
kev

 

[Kevin_S]

Hi Pat,

I just double checked it and the If-Then points to the correct name "pickFill" and not the bound field. The code errors, and then highlights this in the debug window:

If Forms!frmVac_Log!pickFill = 1 Then

I tried using me. as well to no avail.... I thought it might be triggering because the control in question is an option group so I tried to have the If-Then just look a the value of a text field and run but I got the same error - is this typical with unbound forms based on queries or am I getting an error for some other reason...?

Thanks for Your Help,
Kevin

 

[Kevin_S]

Pat,

The control name is indeed in that list WHEN I have the form's recordsource set as the query. This is the way I built the form (with the recordsource being the query) But - for using the form in the application I remove the recordsource for the form in design view, as I am setting this property on the fly through the listbox selection on the previous form. Both possible recordsource selections in the listbox have this field as one of the controls in the queries.

THis is so weird..? I tried creating a new db and importing all objects (figuring I might have a corrupt db or something) but nothing helped....

Any other ideas?

Thanks Pat,
kev

 

[Rich]

Use the timer event

 

[Kevin_S]

Hi Rich/Pat,

Rich- I am already using the form timer event to display the current date/time in a digital clock fashion. Can I add additional code to the event and have this function still work correctly (I'm not real handy with the Timer event as I hardly ever use it except for digital time display purposes. If there is a solution in the use of this event that would be great - as long as it doesn't interfer with its current use (for some reason my users LOVE this display even though I tell them time and again all you have to do is mouseover the taskbar at the bottom of the screen to see the time...)

Additional Note:

This error has to have something to do with the code running BEFORE the form gets the recordsource because if I move the code to the Mousemove event in the detail section of the form everything works fine but - I feel like this is a cheap work-a-round and I think that this will waste resources having the code continuously firing on the movement of the mouse... thoughts on this or the timer event...?

Thanks,
Kev

 

[Rich]

I wouldn't advise running the code alongside your clock, clutching at straws, have you tried DoEvents?

 

[Kevin_S]

Thanks Pat/Rich for the continued help...

Rich - I tried DoEvents and it still didn't solve the problem

Pat - The reason I have the form unbound is that, based on a selection in a listbox on a previous form, the form frmVac_Log can have 1 of 2 possible queries as the recordsource. If I hard code the recordsource to the form in design view then I have issues trying to set it on the fly. The name never disappears from the list - I misspoke and was looking at the bound field.

I still can't get this to work so if either of you have any other possible suggestions I'd love to hear them... if not I'll just go with the work-a-round.

Thanks Again,
Kevin

 

[Rich]

Try re-naming pickFill to txtPickFill on the property sheet, If Me.txtPickField etc

 

[Kevin_S]

Hi Pat/Rich,

I just wanted to thank both of you for trying to help me get this resolved. I was never able to get the form to allow me to hide/unhide the boxes on the opening of the form in the On Current event - the cause of the problem was that in the code on the form that opens the form in question I open the form and then set the recordsource to the query that was selected in the listbox - I had to assign the recordsource after the form is opened because when I tried to assign the recordsource first the code errored as it couldn't find the object so... the on Current event fired before the form had a recordsource and, consequently, the db couldn't find the fields in question.

So - to fix this problem - I added the If/Then code to the code that opens the form on the Double-Click event of the listbox - this way the code opens the form THEN assigns the selected Query as the recordsource THEN test the value of the field and hide/unhides the fields depending on the value of the option group. THis method is not as efficient as the On Current event would be but it is definitly more efficient then the On Mousemove event.

Thanks for you help with this - it really helped me determine what the problem was and where it was occuring.

Kevin