When using a form records are not updating

[BH]

Hi, just tried submitting this thread but does not seem to have worked, apologise if it is duplicated!

After reading through a considerable number of postings I can still not manage to get the records on my form to update!

When clicking on a listbox record the related information is shown on a form. When i update the records the changes are not updating.

The form is set to dynaset.

Can anyone help please! My code is:

Dim db As DAO.Database
Set db = CurrentDb()
Dim RSRef As DAO.Recordset
Set RSRef = db.OpenRecordset("select * from tblPortfolio where Ref_No like '*" & lstResults.Value & "*'")

Txt1.Value = RSRef!Portfolio_no
txt2.Value = RSRef!Portfolio_Eligble_Comment

 

[PHV]

Have you tried the DLookUp function ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[BH]

Hi PHV

No not tried that (ever), will have a go and see what happens! Thanks

BH