Using Excel as "Form Front"

[DragonWood]

Hello,

I want to use Excel as the "Form Front" for my Access database. I want to enter the data for each job via Excel and have it stored in the database.
I would also like to be able to enter the job number into Excel and have it "auto-fill" the rest of the data from the database.

I guess, basically, I want to use a single Excel Workbook as both the "Form" and "Report" feature for my Access database.

Any help would be appreciated.

Thanks.

 

[SydneyGeek]

See if this helps get you started.

Denis

 

[DragonWood]

That looks like it will help, I just have to do those tutorials. Luckily I have a little time to do that.

Thanks.