subform problem!

Hi there!

I have the following problem and no matter how hard I try I just can’t figure out whats the problem! Maybe you could help me in this matter! If you know the solution please help!

I have a database with two tables. One is registering the customers. The other their orders. Of course the tables are linked (customer ID). I made a form of the customer table. The customer form also has a subform in which are listed the details of their orders (date of the order, ordered amount, order ID, and the paid amount). When there are no records registered in the orders table (orders subform) the customer form and the order subform looks ok. But as soon as I set an order in the order table and I try to run the customer form the program shows me the following error message: „This expression is typed incorrectly, or it is too complex to be evaluated. For example a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables.” Now what the heck is that?? Í just dont get it. I have just 2-3 customers and 5-6 orders. Why is access doing this??? What seems to be the problem??
Thanx a lot!!

Can you post a sample of your DB?

S-

yes I could post it but I really dont know how should I do it!..
please explain!
thanx

Ok! I found out how to post! (I told you I was a newebee)

You have it here! Please try to help if you can!

Anyway thanx a lot beeing helpfull!!

Okay here are two things that I did and it appears to be working

I removed the formating from your autonumber primary key (may not be necessary, but it is working)

Changed the "Vevok_sorszam" in table "Megrendelok" to a datatype of numeric. To do this you will need to remove the realationship and then make the change and then recreate the relationship. By word of advice, if you care about the integrity of your data, "enforce referential intergrity" and probably do "cascade updates"



Let me know if you have any other problems

S-

Thanx a lot sbaxter!!!!!!

The solution you told me is definetelly working!

Thanx a lot again!

Please help on my other question!

My question was:
"I try to make the Customer ID (which is also the primary key and it is set to autonumber) to look like this 0001, 0002, 003,.. 0009, 0010,0011… 0100, 0101.. and so on.
On the format of the Customer ID I wrote this:”>> 0000” (without quotations)
My problem is that this autonumber should work this way: 0008, 0009, 0010, 0011.
But this way unfortunatelly it works this way: 0008, 0009, 00010, 00011. I hope you understand my problems. What’s wrong??"

Your answer was:

"I would keep it as auto number and just reformat the number when displaying it with the following code

Format([auto],"0000")"

Where I have to write this code becos I dont know???
Where should I paste this format command?

Thanx a lot!!!!

I'm having a hard time answering your question becuase I simply don't know. I rarely use bound forms. So I usually reformat text prior to putting it into the textbox with the use a VBA code with UnBound forms.

Send a Private message to TBÁrpi he should be able to help you.

S-

Thanx a lot Sbaxter for beeing so helpful! Thanx a lot! I'll write to Árpi! Thanx