Form to display data based on previous record but not all fields

gocoder

Registered User.
Local time
Today, 01:21
Joined
Sep 16, 2014
Messages
10
-There is a form which the user fills in 8 fields and saves it. Once saved, a new record opens.
However, I want to modify the save button to save the previous record and display a new record with only a limited no of fields to display from previous record, say 4 fields display from previous record, and the user fills the remaining 4 and saves it. Thus, the save cmd should continue to display 4 fields from the previous record.Already tried below code for save button but it displays all data of previous record as it is, doesn't display blank space for combo.118 and text2

DoCmd.GoToRecord , , acNewRec
DoCmd.GoToRecord , , acPrevious
Combo118.Text = ""
text2.Text=""
 
Hmm, you need to use something like...

Code:
Forms![TheFormYouAreOpening].[ControlOnSaidForm] = Me.ControlNameForMainForm
 

Users who are viewing this thread

Back
Top Bottom