No values in fields in new forms or queries, only ids (1 Viewer)

aimoFIN

New member
Local time
Yesterday, 16:26
Joined
Feb 13, 2019
Messages
6
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?
 

Ranman256

Well-known member
Local time
Yesterday, 19:26
Joined
Apr 9, 2015
Messages
4,339
don't use a split form.

use 1 master form (single record) the Order,person, total
and a subform (continuous) that has every Item,Qty,Cost, ExtCost

The Order Total is a textbox on the subform footer: =Sum(ExtCost)
you cannot add subform items until the Master form record is saved 1st.
 

aimoFIN

New member
Local time
Yesterday, 16:26
Joined
Feb 13, 2019
Messages
6
I deleted the split form. If I make a new form or query from the Orders table values are not shoving, only ids.
Why the previously made form shows values but new ones does not?
 

Users who are viewing this thread

Top Bottom