Search results

In Design view, choose your text box, then Format, Bring to Front. Hope this helps.

1. Make sure the Main form has Data Entry set to Yes. 2. I think you may be out of luck on the Back Style property. Hope this helps?

Since the record source is already set, you shouldn't need to run the query first. Just open the form. Hope this helps?

Design View Form properties Navigation Buttons Hope this helps?

If you cancel an action query (Append or Delete query) that error will usually come up. In your error handling routine, you can skip this by checking for that specific error number. If Err.Number = 2501 Then Resume Next 'Go to next line of code after error End If Hope this helps?

This !! forms!frmoutershell.frminnershell.Form.frminnerinn ershell.Form Doesn't look like a valid name for a form or subform Forms!YourFormName!YourSubformName.Filter = strSQL Also try to avoid spaces in your form or control names. If you do include spaces, put brackets around Forms![Your...

Another way to use a List box. If you have a bound form you can put a list box on it and when choosing from the list box, you can go to that record on the form.

Easier to take the close button off of the form which will force users to use a command button to close.

Please check you syntax and capital letters OldValue not oldvalue Hope this helps.

In the OnChange property of the combo box Dim strFilter as String strFilter = "[ContactID] = '" & Me.YourComboBox.Column(0) Me.Filter = strFilter Me.FilterOn = True Hope this helps.

If this is a continuous form, maybe you could use a listbox to show your data and it would be visually less confusing. Hope this helps.

This may help http://www.lebans.com/SelectRow.htm

If the Combo box is bound, it needs to be unbound. If the information in it is static you can use a value list instead.

Instead of passing the parameter when opening the form you might want to try opening the form with no parameters, setting a filter then turn on the filter. DoCmd.OpenForm "frmFullPicture" Forms!frmFullPicture.Filter = "[ObjectID] ='" & identity & "'" Forms!frmFullPicture.FilterOn = True You...

Try leaving off "acNormal" and "acWindowNormal" DoCmd.OpenForm destination, , , "[ObjectID] = '" & identity & "'" If that doesn't work you may have some other code in the form that you are opening (Maybe in the OnLoad or OnOpen event) that is causing a conflict.

In the property for all of the other textboxes set Locked = Yes Hope this helps?

Try This DoCmd.OpenForm destination, acNormal, , "[ObjectID] ='" & identity & "'", , acWindowNormal Hope this helps?

You should clear your text boxes in your On Change property of the form.

A report would be your best option. All of your calculated controls should be able to be duplicated on the report. Hope this helps.

Another way would be to use combo boxes and a subform to show your results.