subform datasheet: one field does not show the values

[mls via AccessMonster.com]

I had created a subform for order details and linked this to orders form\
table by OrderId. All the details are showing up in my subform( datasheet
view) except OrderNO, which is a text field. I am using Access 2007. Do any
one of you experienced this kind of issue before?

Thanks

 

[John W. Vinson]

I had created a subform for order details and linked this to orders form\
table by OrderId. All the details are showing up in my subform( datasheet
view) except OrderNO, which is a text field. I am using Access 2007. Do any
one of you experienced this kind of issue before?

Thanks

What are the Recordsource properties of the mainform and subform? If each
OrderID corresponds exactly to one OrderNo, you wouldn't WANT to store it
redundantly in the linked table, and would not expect it to automagically get
copied from the orders table to the subform. More details please!

 

[mls via AccessMonster.com]

OrderId and OrderNo are composite keys in my table. Today I tried to create a
simple FORM with these 2 fields, even then the OrderNo is not showing up.
OrderNo has the values as Order 1, Order 2 etc. and Oredr is a numberic field.
I still could not figure out the reson why my OrderNo is not always blank on
the form

 

[mls via AccessMonster.com]

correction: I still could not figure out the reason why my OrderNo is always
blank on
the form view. In the table it is a not null field so always has one or the
other value.

OrderId and OrderNo are composite keys in my table. Today I tried to create a
simple FORM with these 2 fields, even then the OrderNo is not showing up.
OrderNo has the values as Order 1, Order 2 etc. and Oredr is a numberic field.
I still could not figure out the reson why my OrderNo is not always blank on
the form
[quoted text clipped - 7 lines]

redundantly in the linked table, and would not expect it to automagically get
copied from the orders table to the subform. More details please!

 

[John W. Vinson]

correction: I still could not figure out the reason why my OrderNo is always
blank on
the form view. In the table it is a not null field so always has one or the
other value.

Again:

What are the Recordsource properties of the mainform and subform?

I don't know. I can't see them.

Also:

What is the actual text of your Master Link Field and Child Link Field? I'd
expect

[OrderID];[OrderNo]

(with or without the brackets), but again you don't provide that information.

 

[mls via AccessMonster.com]

I fixed this. The orderno is not showing up when I use wizard, So for OrderNO
I created a text box and in the source I selected the OrderNo and now it is
getting populated. Still not sure why this wizard is causing the problem

correction: I still could not figure out the reason why my OrderNo is always
blank on
the form view. In the table it is a not null field so always has one or the
other value.

Again:

What are the Recordsource properties of the mainform and subform?

I don't know. I can't see them.

Also:

What is the actual text of your Master Link Field and Child Link Field? I'd
expect

[OrderID];[OrderNo]

(with or without the brackets), but again you don't provide that information.