Prev: Look up data from a table in a text box
Next: Date Picker won't appear
From: mls via AccessMonster.com on 18 Mar 2010 11:47
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

--
Message posted via http://www.accessmonster.com

From: John W. Vinson on 18 Mar 2010 12:41
On Thu, 18 Mar 2010 15:47:54 GMT, "mls via AccessMonster.com" <u55943(a)uwe>
wrote:

>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!
--

John W. Vinson [MVP]
From: mls via AccessMonster.com on 19 Mar 2010 09:18
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

John W. Vinson wrote:
>>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!

--
Message posted via http://www.accessmonster.com

From: mls via AccessMonster.com on 19 Mar 2010 09:21
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.


mls wrote:
>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
>
>>>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
>[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!

--
Message posted via http://www.accessmonster.com

From: John W. Vinson on 19 Mar 2010 12:07
On Fri, 19 Mar 2010 13:21:22 GMT, "mls via AccessMonster.com" <u55943(a)uwe>
wrote:

>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.
--

John W. Vinson [MVP]
 |  Next  |  Last
Pages: 1 2
Prev: Look up data from a table in a text box
Next: Date Picker won't appear