Do I need to code the text box?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TechyTemp - 13 Nov 2006 15:47 GMT

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?

Reply to this Message

John Vinson - 13 Nov 2006 17:02 GMT

>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
[quoted text clipped - 5 lines]
>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]

Reply to this Message

missinglinq - 13 Nov 2006 18:05 GMT

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!

Signature

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

Answers/posts based on Access 2000

Reply to this Message