I have database for orders. Tables are Orders, Sales person, Customer and Products.
Problem is that suddenly values aren't shown in fields if I make new query or form. Values are shown in forms which I have made previously.
I was testing different options for user's main form. I was testing form with subform and split form.
Form with subform I made previously and it is working. In this form I have buttons on main form and subform is containing Orders table in datasheet mode. No problems with this, I can see values in fields.
Split form I have Orders table in datasheet mode, form mode is hidden and buttons are in form header. Suddenly I noticed values aren't showing anymore, only ids. This point I was making macro to open record on click. This macro is working.
What I did to cause this? Any help where to look for the problem?
Problem is that suddenly values aren't shown in fields if I make new query or form. Values are shown in forms which I have made previously.
I was testing different options for user's main form. I was testing form with subform and split form.
Form with subform I made previously and it is working. In this form I have buttons on main form and subform is containing Orders table in datasheet mode. No problems with this, I can see values in fields.
Split form I have Orders table in datasheet mode, form mode is hidden and buttons are in form header. Suddenly I noticed values aren't showing anymore, only ids. This point I was making macro to open record on click. This macro is working.
What I did to cause this? Any help where to look for the problem?