Do I need to code the text box?

[Guest]

I have an update form designed to enter ship dates and other information for
orders. I have text boxes for the original order date and promise date. By
the time the ship dates are entered the data for the order and promise dates
is already in the order detail table but it's not showing up on the shipping
detail input form and I've tried stating the source as the order detail table
and it hasn't worked - at least the way I did it.

Do I need to code these two text boxes to pick up this information from the
table?

 

[John Vinson]

I have an update form designed to enter ship dates and other information for
orders. I have text boxes for the original order date and promise date. By
the time the ship dates are entered the data for the order and promise dates
is already in the order detail table but it's not showing up on the shipping
detail input form and I've tried stating the source as the order detail table
and it hasn't worked - at least the way I did it.

Do I need to code these two text boxes to pick up this information from the
table?

Since we have no way to know how your tables are structured, it's hard
to say for sure. You may be able to set the Control Source properteis
of these textboxes to something like

=DLookUp("[Promise Date]", "[Order Details]", "[SomeUniqueKey] = " &
[controlname])

where the SomeUniqueKey is an ID which would identify the right record
in the order details table.

John W. Vinson[MVP]

 

[missinglinq via AccessMonster.com]

Two questions:

What is the Record Source for the update form/shipping detail input form?

Why do you have a separate form for inputting shipping data instead of
including it on your original form? A 2nd tabbed page for the shipping data
would be perfect for this!

I have an update form designed to enter ship dates and other information for
orders. I have text boxes for the original order date and promise date. By
the time the ship dates are entered the data for the order and promise dates
is already in the order detail table but it's not showing up on the shipping
detail input form and I've tried stating the source as the order detail table
and it hasn't worked - at least the way I did it.

Do I need to code these two text boxes to pick up this information from the
table?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com