Search results

finally i solved it! oddly me.requery instead of me.textbox.requery did the job. :confused:

thanks Bakta, what do you mean with refresh mthod ? i have solved it with me.requery instead of me.textbox.requery. now it would be interesting whats the difference that it doesn't work if i only requery the textbox that refers to the value?

following problem: 1) a textbox gets value from a combobox 2) after selection in combobox value exists in table but isn't shown in textbox until form is closed and newly opened -> how do i requery so that the value that is existing is shown instantly??

Ok, its just a missing requery for P_ID and PersonNumber in PresonDetail_form. so whats intresting is why does it requery correctly if i select via mouseclick and don't if i hit enter? so anyone knows where to requery the autofilled textboxes?

well, im doing it via combo box now: a combo box with P_ID and PersonNumber from the person form that fill P_ID and PersonNumber in PersonDetail via: Private Sub Combo26_AfterUpdate() Me.P_ID.Value = Me.Combo26.Column(0) Me.PersonNumber = Me.Combo26.Column(1) End Sub (P_ID is hidden in both...

ok, maybe my post is not very clear. what i have is: person_form P_ID (PK,AutoNumber,invisible) PersonNumber (Number, editable by user) PersonDetail_Button (CommandButton that opens personDetail_Form and opens recordset of...

DesignView -> ComboBox Properties -> Data -> RowSource here you add ORDER BY tablename.surname to your Query

Open Form with specified Recordset and Autofill hi, im a beginner in access and want to do something like that: <edit>this is in the DetailButton_Click() event</edit> stDocName = "PersonDetails_Form" DoCmd.RunCommand acCmdSaveRecord 'open form with recordset of person...