Does anyone know how I can use a spreadsheet to populate fields in a form?
Does anyone know how I can use a spreadsheet to populate fields in a form?
Provide more detail about what you want to do. Where is the form? On a
worksheet? HTH Otto
"Sam" <Sam@discussions.microsoft.com> wrote in message
news:EF1AF1FA-54FE-42C2-9EEF-BDAE2E1FAD19@microsoft.com...
> Does anyone know how I can use a spreadsheet to populate fields in a form?
Put your field names in the first row.
As a minimum, put a line of data in the second row.
Don't leave any heading columns or data rows completely blank.
Highlight a cell within your block of data.
Choose Data | Form to see your data in a form view.
You can search or browse the form or add a new record.
Bill
"Sam" <Sam@discussions.microsoft.com> wrote in message
news:EF1AF1FA-54FE-42C2-9EEF-BDAE2E1FAD19@microsoft.com...
Does anyone know how I can use a spreadsheet to populate fields in a
form?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks