Why doesn't this work?

Skotor

Registered User.
Local time
Today, 09:12
Joined
Jan 30, 2003
Messages
23
Hello all,
I'm working on developing a minor database. I have 1 table with locations and all set location data in that file. I have several tables with sales data sorted by year and month and so on. I have several queries that sort the data how I want it for easier usage and reporting.
I'm trying to make a form that lists fields from the monthy sales and yearly sales tables, with one field for inputing a "reported sales" that will be manually keyed in on this form and stored into the monthy sales table. In that same form I'm trying to display 2 field from the Locations file for them to referance, and if needed change/update those 2 fields as needed via this form.

I create the form and set it up how I think it should look and flow, but all fields are unable to have data entered. I'm getting frustrated and starting to look at a longer and more complex was around my inability to set the form up correctly. Any help or insite would be great. Thanks for your time.

note: no VB skills here, so I hope this doesn't require any special codeing. I don't think it does, I think I'm just over looking something.

Scott
Access Noobie :confused:
 
Go into the forms Properties Sheet and check the following:

Locked = No
Enabled = Yes

If there are subforms, check their Properties Sheet for:

Allow Edits = Yes
Allow Additions = Yes
Allow Deletions = Yes

I got my butt kicked by these once upon a time.

Good Luck!!!
 

Users who are viewing this thread

Back
Top Bottom