RE: Can't get data entry with a form based on a query

If you run query 1, not the form, can you make changes in the fields?
"Joe" wrote:

> geomike.. well, not exactly one table...4 tables, something like this...
> Main table is for projects...
> fields are:
> autonum, date1, text1, memo1, date2, text2, memo2, date3, text3, memo3,
> date4, text4, memo4 and 4 yes/no fields
> I used the wizard to create 3 queries...
> Query1 - if date1 or text1 is not null, it shows all fields thru text2
> Query2 - if date2 or text2 is not null, it shows thru text3
> etc.
> The other 3 tables are used to print out values in a report according to the
> values in the text fields.
> Then I used the wizard to create forms...
> Form1 is for entering data into the date1...memo1 fields
> Form2 (based off the query1) is for entering data in date2...memo2 fields
> Form3 is based off query2
> Form4 etc.
>
> I can enter data into Form1, I'm guessing cause the field values are right
> from the table, but I can't enter data into Form2, I guess because it's based
> off the query.
>
> So that's where I'm stuck, 3 forms I can't enter data on...
>
> Thanks in advance for any ideas.
>
> --
> Just Joe
>
>
> "geomike" wrote:
>
> > First, if you have only one table, it really isn't a database, it is more
> > like a spread ***. You might want to look at database modeling and see if
> > your data can be more efficiently set up at some point.
> >
> > If your form is based off of a query, then even if you used the wizard to
> > create the form, to update the data, all you need to do is change the data in
> > the form. Unless I misunderstand, I just created a very small two table
> > database with only names/ID and departmentsDeptID. I updated information by
> > just changing it. If you are not the only one using this form, you may want
> > to build in some protection to prevent others from making corrections.
> >
> > "Joe" wrote:
> >
> > > Have a simple database, 1 table, I used a query to load a form so that only
> > > the records fitting certain criteria are seen, but how can I update records
> > > from the form?
> > >
> > > --
> > > Just Joe
.

Quantcast