Showing data from linked spreadsheet to a form

[maxinemdk]

Hi there!

I'd like to show data from a linked spreadsheet into a form. How do you do
this? I've managed to link the spreadsheet into the database. The database
has order numbers which matches the Order number in the spreadsheet. The info
I needed to show in the database is the Billing Status according to the Order
number. The Billing status is constantly updated in the original spreadsheet.
What I'd like to happen is the following: In the form, an order number is
typed in and all the info concerning that order is pulled from a database
table as well as the billing status which is coming from the linked
spreadsheet. I'd appreciate any help. Thanks.

 

[John W. Vinson]

Hi there!

I'd like to show data from a linked spreadsheet into a form. How do you do
this? I've managed to link the spreadsheet into the database. The database
has order numbers which matches the Order number in the spreadsheet. The info
I needed to show in the database is the Billing Status according to the Order
number. The Billing status is constantly updated in the original spreadsheet.
What I'd like to happen is the following: In the form, an order number is
typed in and all the info concerning that order is pulled from a database
table as well as the billing status which is coming from the linked
spreadsheet. I'd appreciate any help. Thanks.

Create a Query joining the linked spreadsheet to the local table. Base your
form on this Query; you can put a Combo Box on the form using the combo box
wizard, choose the option "Use this combo to find a record" and have it based
on the orders table, so the user can select an existing order number.