Prev: Print Powerpoint pres
Next: Access import CSV file with comma issue
From: Maracay on 1 Apr 2010 14:37
Hi guys,

I created a form to consult data, the record source is a query that gather
information from different tables, the problem is when I open the form it
shows data already, I want a blank form when it opens, I already tried
including DoCmd.GoToRecord , , acNewRecord in the open from event, but I get
“You can go to the specified record”, if I go to the query I can't modify the
data or add a new record that is why the acNewRecord is not working.

I'll really appreciate any help

Thanks

From: Marshall Barton on 1 Apr 2010 15:20
Maracay wrote:
>I created a form to consult data, the record source is a query that gather
>information from different tables, the problem is when I open the form it
>shows data already, I want a blank form when it opens, I already tried
>including DoCmd.GoToRecord , , acNewRecord in the open from event, but I get
>�You can go to the specified record�, if I go to the query I can�t modify the
>data or add a new record that is why the acNewRecord is not working.


Yes, if the query is not updatable, then you can not do much
of anything beyond viewing the data. That is common for
queries that include just two or three tables. Sometimes,
bot not guatanteed, you can get a query with two or maybe
even three tables to be updatable if you are careful to
include the primary key field from each table

Best would be to separate the query's tables into separate
queries and use those in subforms.

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: Print Powerpoint pres
Next: Access import CSV file with comma issue