Web Development

Ask something
Question Locked

Access Form Fields Won't Accept Data

0 helpful
3 replies

by a former member

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have an Access 2003 database with three tables (TB1, TB2, TB3). Their relationships are TB1 (one-side) to TB2 (many-side) and TB2 (one-side) to TB3 (many-side). TB1 and TB3 have no direct relationship to each other.

My form's record source is all the fields in all three tables through a query. It allows me to enter data into a new record for the fields from TB1 and TB2 but not TB3. When I try to enter data in the fields for TB3 all I get is a beep, but no error message.

I can enter data into TB3 by using the datasheet view for the table itself. Then i can go back to the form and make edits as necessary in all fields for all tables.

I have checked all locks and controls but can find no differences between TB1 and TB2 fields as compared to TB3.

Can anyone suggest anything else I need to try to fix the problem?

3 replies

by Former member

Clarifications

by tintoman

The only thing I can recongise here is that the form property is set to allowedits=false
If this is not the case you could open the VB script and in the private sub form_load() property type form.AllowEdits = True
and see if it makes a difference

by Former member

I double-checked that property as well as the Allow Additions property. Both are set to Yes and still no change.

Thanks for the idea though and if you think of anything else, please don't hesitate to let me know.

This discussion is closed to new replies.