>Here is the SQL for the Record Source:
SELECT [1st time callers].Date, [1st time callers].[User ID], [1st
time callers].Expr1
FROM [1st time callers];
----------
does the above work fine as a saved query? I would make the above as a
query, and then ensure you can open the query and view/browse the records
in
the query builder. Also, can you edit the records using the NEW query you
just built?
I would suggest you get the query working BEFORE you attempt to create the
form.
So, it only a few forms you can't change?
Also, what happens when you open the form in design view, and then switch
to
form view (ie: don't close the form, but keep it open in design view, and
then switch to form view?).
Remember, get the query working first, and then perhaps build a test form
with the wizard based on that query that we *know* is working just fine. I
suspect you deleted a table, or modfied the tables that the form
needs...and
thus they don't want to open in "user edit mode" but continue to allow
opening in desing mode...
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@[EMAIL PROTECTED]
|
