Can not figure out form 1

[Trekk]

I have 2 forms, that I am trying to get them to work together.
I have a one to many relatioship, Meaning that in Table A there is a primary key and in table B there is a primary plus I added in the key from table A.
I created a form with table A and I added a subform table B.
When I first enter data all is fine but when I go to a new record I always get an error(The expression you types is incorrect or too complex.

Please give advice

Thank you

Trekk

 

[gusbrunston]

Dear Trekk:

I've noticed the absence of answers to your two posts on this question. I'm not an expert, but I'm always ready to give advice about things I don't know much about, so take all this with a grain of salt!

I think the reason there has been no response to your post(s) is that more information is needed to understand the problem.

For example:
1) You write, "When I first enter data all is fine." Is that data saved in your table?
2) What do you have in the "Link child fields" and "Link master fields" in the data section of the property sheet of your sub form?
3) Does form A display records from table A? Is table A the "one" side of the relationship?
4) Does the sub form display records from table B? Is table B the "many" side of the relationship?
5) The error message suggests that the problem may be in a calculated field. You may be trying to calculate a value, "expression", that has an error in the syntax. Have you looked at these expressions in the data source, table or query?

Someone else may have a simple explanation for your problem. If they don't I'll try to share the effort to solve this with you. Why not let the "wizard" help you create another, very simple form from the same relationship, and see what it puts in the data sections of the property sheets for the two forms?

Good luck: Gus Brunston
An old PICKer
padregus@home.com

 

[montrose]

Do you have the form design based on a query using the two tables? I agree with gusbrunston. Perhaps you could post the qry/sql for additional help.

 

[Trekk]

thanks for ssetting me straight "gusbrunston"
I am new to this, I will try to explain better.

I have created a tasking database.
1 table has fields so Users can enter there request.
the primary key is (TaskID)

I then created a second table called status
The primary key is (StatusID). I have also added table ones primary(taskID) to the status table.
I then created a relationship joining table 1 primary key(taskID to the foreign key(TaskID.
I then created a form with Tasktbl as the main form.
After that I created a subform with the statustbl

 

[Trekk]

Continue>I want to be able to fill in the main form and tab down to the subform, so page one in the main form equals page one in the subform.

I can complete one whole page on the main ansd subform and save it.

I get the above error when I try to do a second page. Ther error comes as soon as I start typing on the second page.

Thanks
Trekk

 

[gusbrunston]

Dear Trekk:
We were all "new" at one time...I'm still "new" about many things in Access.
I think we still need more information.
1) Why are you using a subform?
2) Are you trying to add/edit/save data in both tables, or just one?
Maybe "The end justifies the means" but it's not clear what you're trying to do. What information do you want to save in both tables? Maybe your two tables should be combined into one (on the surface it looks like that is the case). If you want to send me a "stripped down" version of your database by email, I'll take a look at what you're doing and see if I can make better suggestions.
Best of luck. Gus Brunston
An old PICKer
padregus@home.com