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
||4/1/2010 6:37:01 PM
>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.
MVP [MS Access]
4/1/2010 7:20:25 PM
(page loaded in 0.064 seconds)
How to open a blank form for adding a new record - microsoft ...
Hello, I have a form for adding/viewing employee records. I can open the form, view records and using the navigation button, add a new record just ...
opening forms to a blank record in Access 97 - microsoft.public ...
I am trying to have Access 97 open up to a blank record to be filled in but still be able to search for old records using the search or find functio...
Having a blank, new record for entry when you open a form ...
I have a Command Button on my Members Form that opens a Payment Form. What I need is a blank, new record for data entry when the Payment Form opens. ...
Subform opens blank - microsoft.public.access.forms
When I first open my form, the subform has the correct number of records in it, but the records (consisting of a combo box and a couple of text boxes) are blank.
Open up on blank record - microsoft.public.access
how do I open up access form and default to empty record rather than 1st record in the database? TIA ...
Form Opens Blank/Appears as if Filter Applied - microsoft.public ...
Hi, I have an access app in v2007, deployed via the runtime. I have initially installed on 2 machines, both running xp with all sp's/updates app...
How To Have A Form Start With A Blank? - microsoft.public.access ...
Put the following code in the OnLoad Event of the form DoCmd.GoToRecord , , acNewRec This will open the form in a state that is ready to enter a new record, but ...
Data entry form opens up as blank page Access 2007 - microsoft ...
Hi - I am so eager to get feedback on this. I have a simple little data entry form (Detail) that appears as a button on a switchboard form (Manager)...
Open Form with macro and data from Selected Record - microsoft ...
I get the blank form to open up when they double click, however I cannot get the data for that record to show up. I either get a blank/new record or all records.
View all records but start with blank record - microsoft.public ...
Hello. I have a Sales Leads form that users will be entering new leads into. RIght now I have data entry set to yes so when they open it they get a ...
How to open a blank form?
Can anyone tell me how to start with a blank form when I open my access database? When I open it now it opens with the last record entered.
Using MS Access: Opening new blank form, add data, data entry
add data, data entry: Hi Janet What you will need to do is on the property window for the form go to data tab and change the data entry to yes. This will only allow ...
MS ACCESS :: Blank Form On Open - BigResource: Webmaster Scripts ...
Blank New Form Is No Longer Blank? Hi guys, I have been running the same database on numerous systems for 5 years and the user clicks on a button and using this code;
Using MS Access: Open Blank Form, ms word document, autoexec macro
Expert: Scottgem - 5/12/2004. Question My question is on opening the blank form. I have the form view run on start up, is there code that I can write to get it to ...
I want my form to open blank7/25/2012 9:45:23 AM
I am using Access 2000. I am trying to get my form to open up blank. So that when a user prepares to enter information in the blanks there is no data