Subform refresh only

[Garn77]

I have tried in vain using refresh programming to overcome this,

I have a main form that records site and date information. Within this there is a subform that records a number of fields that are standard, but differ according to site location, so that it appears like;

Offsite1 Onsite1 Offsite2 Onsite2
a a a a
b b b b
c c c c

So what I want is for the main form to record that site and date info, with a subform recording the above listed info. One new record within the corresponding table will be created for each grouping (i.e. Offsite1).

To do this effectively, I want to go to the next record once I have filled in the information for Offsite1 for example, this will record the site, date and Offsite1 information in the table. When moving to the next record however, I want the site and date information in the main table to remain or be copied across. The subform will clear as it is a new record and so will the main form normally.

Can anyone help?

 

[ansentry]

If I understand you correctly you want the be able to enter data in main form and subform , go to new reocrd and have the previous data copied from previous Main form only and NOT the subform data.

If I am correct then have a look at this post HERE

 

[Garn77]

Ansentry

Thanks for the advice, this is what I am looking for. However, in trying to reprogram the code I am experiencing trouble and having errors accessing a file??? Can you assist further, sorry a beginner with code formatting

 

[ansentry]

Which sample of mine are your talking about (there are 2 on the link I posted for you.)

Also what version of Access are you using?
What does the error code say?
When does it happen (the error code)

What do you mean by this;

having errors accessing a file???

To help you it may be better if you post a copy of your database (with dud data) and indicate what form you want "copied".

 

[Garn77]

Using Access 2000

I have included a temp version of the database to illustrate what I want to achieve.

For each entry into the form I want to record all fields from SiteRegisterID through to DisposalD fields. After the first entry I want to select the "Next Entry" button which will move the form to the next record and in the same process copy across the previous SiteRegisterID, Site Name; Location; Facility; Quarter and Year fields. Only the Disposal Type and Disposal fields will be blank.

The form will ideally be blank rather than contaning the old records at the start of each session as well.

The error message stated that there was an error accessing the file and basically I got no where with it

 

[ansentry]

Here is your sample back;

When the form opens it will open to the last record.
I put a message box in there, to show you that the new record had been created, just rem it out if you don't want it.

 

[Garn77]

Ansentry

Thanks heaps, perfect solution