I am working with the northwind database and adding to it for my need.
I have a parts detail form that when opens all the fields are empty. It is set to open to a new record.
There is a combo box in the header that allow you to chose a part number and then all the information is displaced in the detail.
The problem I have is that when you go to chose another part number in the combo box the records will not change.
I think that my problem is in the code on the On Got Focus
I have a parts detail form that when opens all the fields are empty. It is set to open to a new record.
There is a combo box in the header that allow you to chose a part number and then all the information is displaced in the detail.
The problem I have is that when you go to chose another part number in the combo box the records will not change.
I think that my problem is in the code on the On Got Focus
Code:
[OnError
Go to Next
Macro Name
If [Screen].[activeForm].[Name]=[Form].[Name] Then
Requery
Control Name =[Screen].[ActiveControl].[Name]
end if]
Last edited by a moderator: