Search results

Try putting that same code in the On Close event of the form that your adding a new card to. HTH Shane

Hey Mike, On the form for the EMP_DETAILS I have a command button to open the form for EMP_ADDRESS (for inputting). I have set this to open the second form on the record relating to the current EMP_ID as displayed on the first form. On the second form, the form being called, have you set the...

Is that a macro that's passing the value? No, it's VBA How and where do I add the additional field in the control box? In your combo box go to properties and click on the second tab. There you should find Row Source. Click on the ... button to the right of the field. This will take you to...

Hey Dome, In your combo box add the fields from the products table that you would like displayed. Set the column width for those values to 0 (unless you want the user to see them in the combo box), then add unbound text boxes for each value that you want. After you've done that in the combo...

Hey j6niner, I think I'm following what you want to do. If you have the employeeID in all the tables that contain the values that you want. You could go to the combo boxes Row Source property and build the query behind that combo box using all the tables involved and use the EmployeeID to...

Robin, When the form opens, which field has the focus? Is it a field that is in the middle of your form? Is your form designed to be bigger than the screen resolution that you have set on your computer?

Robin, It sounds to me like your saying that the form is opening in the correct position but inside the boundary of your form it's opeing in the middle of your form design. Is this correct? Do you have multiple pages in your form? If that's correct check your tab order and see if it's...

In the combo box properties. You've gone to the Event Tab, then to After Update event you've chosen Event Procedure, then clicked the ... to the right of the field box and pasted the above code? If that's correct then I'm not sure why the code would not work unless we have the names of the...

If Me![Payment Method] = "check" Then Me![Check#].Visible = True Else Me![Check#].Visible = False End If Give that a try and let's see what happens.

One thought that may help. Set your text box for check # visible = false, then in your combo box After Update add code something like this: If Me!ComboBox = "Check" Then Me!txtCheckNumber.Visible = True Else Me!txtCheckNumber.Visible = False End If You will probably need...