In the attached DB when I enter allocation the Dept. is automatically entered. But it is not saved in the table Tbl_ALLOCATIO-I. How to solve this problem?
In the attached DB when I enter allocation the Dept. is automatically entered. But it is not saved in the table Tbl_ALLOCATIO-I. How to solve this problem?
Haven't I given you explicit instructions in another thread on how to accomplish this?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
That site is closed for update.
I am trying to update the table field in different events but without success. Please guide me. Updating the table field very important. I have attached the DB.
Here is my advice:
1. bind form to Tbl_Allocation-I, not query
2. bind Dept textbox to Dept field not Dep
3. combobox properties:
RowSource: SELECT ALLOCA, DEP FROM ALLOCATION ORDER BY ALLOCA;
ColumnCount: 2
ColumnWidths: 1";0"
AfterUpdateEvent: [Event Procedure]
4. code
Private Sub Combo32_AfterUpdate()
Me.DEPT = Me.Combo32.Column(1)
End Sub
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.