Invisible combo box

[FJM]

I have a form which contains details of a SUPPLIER and on the form it has a standard combo box which is used to select a specific account for the user to view.


I want to now call up the details of a specific supplier on this form but instead of using the combo box to choose the supplier, I want to use an account number on a completely different form.
I have created a simple macro and this works.
I want the original combo box to now become invisible if I choose the supplier using this route.
Is this possible

[ranman256]

'open the form
docmd.openform "frmSupplyDetail"

'hide the combo
forms!"frmSupplyDetail!cboBox.visible = false

[FJM]

I only want the combo box to go visible if the form is opened up via the "second" form i.e where the supplier account matches.
I want the combo box to remain visible if the user chooses the original form to look at the supplier details.
At present the supplier form is made up of a list of suppliers.
The user can go into the form and by using the combo box look at the details of any supplier they choose.
The "second" form has different details on it about a parts which is linked to specific suppliers.
When the user has this form open I want them to be able to click on the supplier which will then open up the original form but will be filtered so that the supllier numbers match.
It is at this point I am wondering if the combo box can go invisible.
The macro that currently runs will open the form where I want it to

[orange]

FJM,
Are you saying that only certain users can see certain Accounts/Suppliers?
If this is correct, then you may need a "UserCanSee" type table where
user X can see Account 1, 20 ,34
user Y can see Account 1, 2, 3, 14
etc.
Then you control Access via your "controlling table".
If I have not understood, then please give some more info and example.
It seems that if the user selected a different entry from thee combo, they could still see the details.

Good luck with your project.

[FJM]

I don't want there to be any restriction on users. I only want to know if, in effect the combo box can toggle between visible and invisible depending on which method is used to open the form i.e visible if opened directly and invisible if opened via the second form

[JamesDeckert]

you can pass info to the form via openargs. Then in the Load event of the form, check what is in openArgs to set the combobox visible or not. There won't be anything in openArgs if opened directly
DoCmd.OpenForm "frmName", OpenArgs:="Parameter(s)"

load event of form --------
value = Me.OpenArgs)

[FJM]

Not too sure what to do here as my coding skills are less than basic but I have done a work around by simply copying the form and removing the combo box off the copy.
Thanks for your help anyway