Split From is Locked

[DanKoz]

I have a split from that is used to review data and allow for changes to be made. The form is based on a single, simple Select query that references the main table (tblPresentations) and a date table (tblReportDate) that restricts the data that is selected to within the date range. I have set no other properties and there are no relationship links between the tables.

When I open the form, or even open the query directly without using the form, for that matter, all the data is locked. This happen even if I do not make any reference to fields in the date table in the design view of the query, i.e., it just sits there. If I remove the date table altogether from the query everything works fine, except I get records I don't want to see or edit.

If I create a split form based on the table directly everything works fine.

Is is not possible to generate an updateable recordset in a split form if more than one table is used in the query?

I have looked at this page http://allenbrowne.com/ser-61.html and none of those conditions seem to apply.

Thanks for your help.



Dan

[rpeare]

what do you mean by a 'split' form, do you mean a form/subform arrangement? And why are you creating a query that's based on two tables with the hopes of doing data entry? If your tables have a 1 to 1 relationship they should likely be in the same table and not separated. If you're trying to lookup values from the second table as you do data entry that's another problem.

[DanKoz]

By split form I mean one that Access creates using the More Forms option in the Create tab. It shows the same data in two different views, the traditional datasheet view and a from view for the one record selected in the datasheet view.

Only one table has data in it that I want to change. The date table is only used to filter the records that are selected from the main table so that the form does not show every record from the main table. I only want to see records from the main table that fall within a given date range.

[rpeare]

If you are using the second table to limit your data set you don't need to do that you can just set criteria on the query running your form or apply a filter to your form.

Let's say you have a form called frmDataEntry
On that form you have an UNBOUND text box named DaySearch

The query that runs your form can be:

SELECT * FROM tblYourTableName WHERE ((DateFieldName) = #" & forms!frmdataentry!daysearch & "#)"

Then you can set the ON EXIT Property of the DaySearch text box to be me.requery

Then whenever you type in a new date all the information relating to that date will come up on your form and you shouldn't have any issue with locked records.

[DanKoz]

OK. Thank you.

Being somewhat new to Access this is a bit above my head but I think I understand the direction you are going. I will give it a try.

Thanks for your help.