Search results

Thanks Travis, I used the Nz function and it solved the problem.

My data entry was working fine (I thought) but suddenly today, whenever I start to enter data in a new subform record (single form) I get the invalid use of null error. (I can add subform records if the main record already has related records, but I can no longer add related record #1 on a new...

I have a form with 4 tabs. The OnCurrent event of the form sets the focus on the first tab. The first control on the first tab (control #1) has an exit event procedure, which sets the focus to the second control after (skipping the next control). Therefore after going to a new record, if I click...

I had the same problem, tried the tab order suggestion (the new field was an unbound text box) and it didn't work. Then changed the unbound text box back to Visible (Assuming that hide = set Visible property to No). Now the tabs are visible when I go to the page. However, the focus is on the...

Could not see any stray periods in the events. Also, I'm not sure how to debug. Can you explain how to put a break on the statement and single step through the loading of the form?

Sorry Pat, resizing didn't work. However I have managed to fix that problem in that the tabs now will show when the form is first opened, however I am still getting a message "can't find the macro '.'" I do not have a macro '.' that I know of. How can I get rid of this message?

Thanks Rich! All I needed was to change it to IsNull(Me![ElimCode]) and it worked. The only problem is, now when the form is first opened, the tabs have scrolled out of view. Any ideas?

I have a main form with a tab control. On the first page of the tab control I have a combo box, ElimCode. I want to show or hide 2 controls on the second page, Criteria_Met and On_Therapy, depending on whether ElimCode is null. (The controls should be shown if ElimCode is null, and hidden if it...

I tried this code and it worked, except that when I first open the form, it gives this message: "can't find the macro '.' The macro (or its macro group) doesn't exist, or the macro is new but hasn't been saved. Note that when you enter the macrogroupname.macroname syntax in an argument, you...

Thanks Elana. I had the same problem and this solved it.