Form Record Source from Joined Query 1

[jamez05]

Hi,

I'm using MSAccess2003. I have a query that joins two tables together and is used as the record source of a subform. Access seems to not allow you to perform updates on these fields because the records are pulled from two different tables. For example, the Latin Name comes from the species table and Common Name comes from the data table. The query links the two tables by latin Name.

When I try to type anything in the form fields that show this information, it won't let me type in there. Is there a way to allow this?

 

[fneily]

See:
Harnessing the Power of Updatable Queries

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaraccess/html/msdn_harness.asp