open Form from form

[Smrle]

Hello everyone.

I have a small problem. Lack of creativity.
I have a small (personal) database.
In the development of user forms I have imagined that the "LOCATION" form of the "ADD_" button opens the auxiliary form "SAMPLE".
In this auxiliary form is a field "CBox_ID_LOCATION" (drop down menu) that has more values.
I suppose I would have to type the code in the main form to run this action.

'Private Sub Command_ADD_SAMPLE_Click ()

DoCmd.OpenForm "edit_SAMPLE", acNormal,,, acFormAdd, acDialog, "Add sample ...."

Me.Form '.Form & "edit_SAMPLE" & CB_ID_LOCATION.DefaultValue = 2

End Sub

But that code does not work

You got a better idea

 

[June7]

Why not set DefaultValue property of combobox in design?

 

[Smrle]

I know about that possibility

The idea is that a form of the same format and shapeis used to enter different patterns.

I do not want to work 8 forms and set each of them a default value

I want one form I'm running over 8 different buttons.
And in the code of each button i want to define the default value of that field (CB_ID_LOCATION)

 

[JHB]

Post your database with some sample data, zip it!

 

[June7]

Well, don't use Me. unless code is the form you want to affect.

Forms!edit_SAMPLE.CB_ID_LOCATION.DefaultValue = 2

I prefer to have code in the form that code is affecting.

 

[deletedT]

I want one form I'm running over 8 different buttons.
And in the code of each button i want to define the default value of that field (CB_ID_LOCATION)

Instead of setting a default value for the combobox, set a function.

In the function, check which button is the trigger that opens the form.
If button1, then Defaultvalue1
If Button2, then DefaultValue2

and so on.

You can use OpenArgs for recognizing the trigger button.

 

[Smrle]

Sorry for waiting
I had to clean the base of different data
At the beginning, when the main shape is opened, clicking the button opens the auxiliary form.

But for each page (item type) "CBox_ID_LOCATION" must have another value.
The buttons have the name (CmdB_01, CmdB_02, CmdB_03, ...)

I hope you understand my problem

 

[Smrle]

Thanks for the ideas

but I am an ambitious beginner
which jumped to the end of the lesson
I do not have the knowledge
But I'm persistent.
I'm working with trial and error method
I like the idea with OpenArgs, but I do not know in whitch form I enter the procedure

 

[JHB]

Sorry can't open your database, seems to be corrupt - hopeful others have more luck.

 

[isladogs]

Also unable to help.
I can open the database and the edit sample form but get an OLE server error with frm_MJESTO

 

[Smrle]

I am from Croatia
Probably a problem in regional settings

I have solved this in the following way