Subform: Value you entered isn't valid for this field

[snowboarder234]

I get the error message as indicated above in the Post New Thread title when trying to enter test data into the subform. However, when I click away the error message then I'm able to enter the data. Another curious anomaly is that the Street Address field automatically inserts the text #Error in the StreetAddress field when I click OK on the error message.



So to recap: I get an error message:Value you entered isn't valid for this field, when I try to enter data in the firstName field. Clicking OK allows me to continue data entry, but this action automatically produces the text #Error to display in the StreetAddress field.

[John_G]

Sounds like there may be some VBA code in the form that isn't right, or there may be some data macros in the tables. Take a look at "View Code" while in form design view.

[snowboarder234]

All it says is: Option Compare Database when I click on View Code while in form design view.

[snowboarder234]

Okay, I've made minimal progress. I guess the problem was I had my heart set on having the Borrowing History subform on a tabbed page onto itself. When I abandoned that dream I dragged and dropped the subform onto the first tab (Books), and everything started to work -- which presents me with another problem. The form is now, dare I say: UGLY! The subform (which now resides in the form footer) is now covering up half of the main form and there's a white chunk of space that extends horizontally across the page. How do I rectify this and is there any possibility of getting the subform onto the tabbed page entitled "Borrowing History?"

A screen shot attached for your viewing pleasure:

[John_G]

.... having the Borrowing History subform on a tabbed page onto itself

No problem with that - but see below on how to do it.


For the error messages you are getting - are there any validation rules set for any of the fields?

Another possibility is that the error is not being generated by the subform, but by the main form when you leave it to move to the subform. You may be entering invalid data into the main form.

... I dragged and dropped the subform onto the first tab (Books)

That doesn't work - it only looks like it does. The subform is still on the main form.

To move it to the tab:

- Click to select the subform control
- Put it on the clipboard with Ctrl-X (cut)
- Click to select the tab you want to move it to
- Copy the control to the tab with Ctrl-V (copy)

This will put it on the tab, but you might have to move it (drag & drop) too where you want it on the tab.

[snowboarder234]

That information was a lifesaver. A couple a days ago another forum member(s) advised me about the Ctrl-X, Ctrl-V method, but I was having so much trouble with this form I was afraid to attempt it again, but it worked!

Now I'll have to do some redesign to accommodate the fact that the Borrowing History data is in a horizontal layout that is wider than the original size of the form. But that's minor, as long as the subform is working: syncing with the right book and feeding information back to the correct table I can't ask for much more than that.

Wish me luck -- I have to do this two more times for the Periodical and Multimedia forms. Thanks for your assistance.