How to Change a Form into Data Access Page

[Alan]

Access XP will not let me save a form as a data access
page. The problem seems to be when I try to save it as a
data access page when there are more than one drop down
boxes (liking to other tables in the database) in the
form. PLease help

 

[Patty]

I just had the same problem myself. In Microsoft's
Knowledge Base I found Article -293357 which helped me
solve the problem.

Your problem may have to do with having your drop-down
selection choices come from a table. The data access page
wants you to make a query of the drop-down table fields
and use the query as the record source for the drop-down
fields (instead of hooking them direct to a table). I
ended up getting it to work by actually copying the SQL
select statement from the drop-down table query into the
recordsource of the form drop-down field.

Hope this helps and isn't too confusing. You'll probably
want to look at the actual article.

Patty