code for refreshing form?

[ICTkirsten]

Hello,

I have 2 subforms on my form and i wanted to be able to view the next record ( on the normal form not the 2 subs) once the save button has been clicked.
Ive used me.refresh but it just refreshes that subform and not the entire form to allow me to view the next record...

ive also used DoCmd.GoToRecord , , acNewRec which again just removes the subforms data entry and not the entire form to view next record..

please help me

Thank you all

 

[Gasman]

Possibly Me.Parent.Refresh?

http://ss64.com/access/syntax-references.html

 

[ICTkirsten]

still doesnt work

 

[jdraw]

You could try (untested)

Me.Recordset.Movenext
or
Me.Parent.Recordset.Movenext

 

[ICTkirsten]

Just tried, they dont work or am i meant to replace some of the words in there with my own?

 

[Gasman]

Are you definitely moving to the next main form record?

 

[jdraw]

How about posting your database, and directing us to the exact issue?

 

[ICTkirsten]

Ive got an appointment form that displays a customers appointment details and with this are 2 subforms 1 of which is for data entry, the other is for reference.


--
And this is for my school project which im not allowed to post up incase someone was to access it and use as their own ( just saying because many people respond to this by saying i shouldnt be getting help either but no its for protection)

 

[jdraw]

It is difficult for readers to guess at your table structures and your form details and to provide focused info/responses.

Can you show us some jpgs (table designs/relationships/form-subform/ event procedures etc. as jpgs not a database.

 

[ICTkirsten]

Thank you,

Just thought i would add that that the sub forms do not run any queries apart from the history which is just a select top 10..

il attach the last image in another reply as it all wont fit

Thanks so much for your time

 

[ICTkirsten]

the remaining images

 

[jdraw]

How about a jpg of your relationships window - make sure you open the Tables to show all fields.

 

[ICTkirsten]

here you go

 

[jdraw]

On your help_form_1 jpg, how does the data get into the main form? I'm assuming that New and History are the subforms.
You have navigation control on History. I'm really not seeing the linkage between main and subform???? Can you explain?

 

[ICTkirsten]

ok so,

The main is based of the query which generates the appointments today so thats how the main form was made..

On this form i have a subform which allows me to add new teeth details
The other subform is just previous records of the customer to help with appointment ( no purpose really just used for looking at records)

im sorry im not being clear please ask more and il try my hardest

 

[ICTkirsten]

the image help 2 is the query used for help form 1

 

[Gasman]

So what is the code behind the Save button?
Are you saying that when you press the Save button to save the 'New' details you expect/want it to move on to the next customer?

 

[ICTkirsten]

The code behind it was just to prevnt blank fields so just notnull statements.

and yes thats exactly what i want

 

[Gasman]

The code behind it was just to prevnt blank fields so just notnull statements.

and yes thats exactly what i want

So what is the code behind the button?

Please post the code in a code block by using the # icon