hOW TO ADD A FORM TO DATA ACCESS PAGE? 1

[Starrizzo]

I have a page on company intranet that I need to be able to link my existing table to. I can bind my fields but how do I get them to add new records to the table?

 

[fneily]

Hmmm. First your title - you can't add a form to a Data Access Page (DAP). Forms are in Access, DAP's are web pages. Two different beings.
Next, create your DAP from scratch using the Page object in the database window. To make DAP's updatable, you MUST include the primary key of the table on the DAP.

 

[Starrizzo]

So if i drag the fields onto the DAP from my table, can they be updated that way. I want employees to be able to input information

 

[fneily]

If you're talking about designing in the Page object, then yes, but don't forget the Primary Key.