Form resizing when refreshed

[parry]

Hi, I have a Tab Control in a form that is resizing. The form is opened as read only, and if the User selects an Edit button, they are then able to edit the record.

For some reason the Tab Control is dropping down when switching to Edit mode.

Heres the code for the Edit button - any ideas on why form is resizing?

Private Sub Command211_Click()
On Error GoTo Err_Command211_Click


DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
Forms!Form_enter_edit_record.Refresh
Forms!formsearch.Refresh

Exit_Command211_Click:
Exit Sub

Err_Command211_Click:
MsgBox "Please Click the Edit Button to Delete"
Resume Exit_Command211_Click

End Sub

 

[Corticus]

Hi,

A couple ideas:
Check the 'AutoResize' property of the offending form, try setting it to 'no'. Also, it sounds like by pushing 'edit', your users are going right to the table containing the data they need to edit. Instead of that, you could insert a subform that links to the table you need to edit. If you didn't want the user to see the subform until they hit edit, add code like form1.visible = True to the pushbutton event. To make it return to invisible, add form1.visible = False to an event that happens after they edit, like maybe the subform.lostfocus event?

HTH,
Corticus