Field Input problem

[Tommy408]

I can't change any of the data on my form. It is connected to a table. I open the form from selecting an item from a List Box.
Form property:
Allow Edits: Yes
Allow Deleteions: Yes
Allow Additions: Yes
Data Entry: No
Recordset Type: Dynaset
Record Locks: No Locks

The selected record is shown. When I try to change the data on the form, it only beeps. Anyone know how I can change this?

 

[Tommy408]

Form A Record Source:
SELECT ID, Name, Category FROM ActiveAccounts UNION SELECT ID, Name,Category FROM OldAccounts;

The text box control source on Form A: Opened Date

I'm gathering data from two tables into a List Box on Form B. I got Form A to show the data when I select an Item on the List Box of Form B. But I can't edit any text box ( Name,Category) on Form A.

 

[Tommy408]

Correction:
Text Box 1 control Source on Form A: Name
Text Box 2 control Source on Form A: Category

 

[Tommy408]

Still need help.

 

[JerryKlmns]

Tommy408

UNION queries are NOT updatable.-

Take a look also here

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp