Can't update data from a form based on a query

[huggybear]

I have to create a form that displays data from 4 tables, and hopefully allows users to update that data. I can get the data to display by basing the form on a query.

However, all the text boxes seem to be locked and I can't create new records.

My client would like to see all this data on one row so I have been trying not to use nested subforms.

Questions:

1) What goes on when a form is based on a query?
2) Is it possible to do this as I am trying to without completely denormalizing my tables?

Thanks in advance.

Bear

 

[jebry]

Hi Bear!

If the data has some natural 'grouping', you might have better luck using one table as the main table and group the rest of the data into one or two smaller queries and put them on the main form as subforms. As a guess, your database is giving you trouble here because two or more of your tables have a relationship established that requires a record in one of the tables before a record can be added to the other table.

Of course, I could be way off base here. Maybe you could post the structure of your tables and the query the form is based on so we can get a better idea of what is going on.

hth Jeff Bridgham
bridgham@purdue.edu

 

[ToeShot]

Also the Only query that yopu can update or change is the select query. If you are not using a select query then you won't be able to do anything but look at the data

 

[huggybear]

Hi to you too!

Jeff: Yes the tables have that type of relationship. I guess I'll have to play around with subforms to get what I want.

ToeShot: It is a select query but it apparently doesn't work because of the relationships as Jeff suggested.

Thanks to you both!

Bear

 

[huggybear]

Hello,

If anyone is still paying attention to this thread, here's what I've decided I'm trying to do and still haven't figured out how yet.

What I'd like to do is create a continuous form with a subform on it. Of course, that is not allowed. Is there a way to simulate that situation?

Thanks, Bear

 

[ToeShot]

use 2 separate subforms on a main form. Don't associate the main form with anything. Have one subform as the Continuios form and the other foe what ever intentions you had.