VBA Help

[AndyPandy]

Hi there

I have created the following database and want to know if the following is possible I have no programing experience so would like to know if anyone can resolve this bit for me.

I have a main form called non contracted call out form and then a form called call list.

from the call list there will be a command button called add new call to previous customer.

When you click on this i want it to load the non contracted form up as hidden exceptt for a drop down box which will list the company name and post codes that have already been entered into the database, when i select one of them the rest of the form will then appear with the customer address details pre populated and then in the job details section will display as though I am entering a new job for the customer above.

I know how to create the combo box control. but I only want the combo box control to disply when the above mention button is pressed from the call list screen. if the new call button is pressed i do not want it do display.

cany anyone help. Hope this make sense

 

[gemma-the-husky]

you can do this in one from probably. Maybe this idea will help. put the combo box in the form header, and set the detail section of the form as visible=no. When it opens all you will see is the header.

after you select something in the combo box - this command

runcommand accmdsizetofitform

will then expand the form to full size.

 

[AndyPandy]

Thanks.

I am trying to do without altering the main form the only way that would work realy wouldbe to have a duplicate form set up running that command, I idealy want to try and do it on one form but have the command button on the call list form tell the form what to do when pressed etc. as the other button new call will just open the form as per normal.

could you show me an example