Not getting newly created record when Searching in split form (1 Viewer)

akika

Registered User.
Local time
Today, 13:19
Joined
Aug 7, 2018
Messages
102
Hi,

I've created a form split form using the wizard link to a table that already contains data.
The forms contains text box and 2 buttons "Name Search", "Add record".

When adding details in the form textbox and click on add button the data getting saved in the table.
But i am not getting the new data created in the form when searching for it.

if i amend the same data in the table and search it is ok.

Any idea whts wrong?

[Name] Like "*" & Forms![frmCustomer]!Text2 & "*" And [PinCode] Like "*" & Forms![frmCustomer]!Combo24 & "*"Searc
 

Gasman

Enthusiastic Amateur
Local time
Today, 21:19
Joined
Sep 21, 2011
Messages
14,274
Try requerying the form?
 

Gasman

Enthusiastic Amateur
Local time
Today, 21:19
Joined
Sep 21, 2011
Messages
14,274
No, you just issue Me.Requery in the form code.
 

Users who are viewing this thread

Top Bottom