Invalid Use of Null

[ASherbuck]

I did a quick search and really didn't find anything related to this. Though, I'm sure it's pry happened before.

I have started work on a new front end and have several linked tables to our back end. As well as copies of them for the purpose of the front end. On load the backend tables update the front ends tables, and on exit the front end tables append/update the back end tables.

I began work on a data entry form for fields residing in the front end tables and found that when I attempted to make a command button for the purpose of record navigation I received the error "Invalid Use of Null" and all of my options were empty (Concerning the control functions) and everytime I changed action categories i recieve the same error.

Also, I tried to work around it with a combo box for searching, only I don't have the option available to make it search.

So . . . I tried to circumvent with an unbound text box that performed a macro searchforrecord but I receive and error that the table I'm search within is not open.

Any clues would be great, any fix would be immaculate. I'm a bit flabbergasted.

 

[KenHigg]

I'm kind of at a loss as to the purpose/advantage for the updates on load and exit - ?

 

[ASherbuck]

Not to be rude but I'm really just interested in why I'm getting that error when I try to add a command button.

I'll tell you all about it in PMs if you're really interested, it's not my design I'm just stuck working with it.

I just tried it on a blank database, I get the same error so is this an occassion where access needs reinstalled?

 

[ASherbuck]

Go figure, simple restart fixed it.

Funny how after hours you don't think of the simple things til you just go smoke a cigarette.

 

[KenHigg]

Glad you got it working