How to Change Default Form Function

[DD999]

This is weird. I've created a form thatI want to use to add new data or edit existing records.

Using a combo box I want to select customerID and then have cust_name and cust_address show up. All info is in the same table.

Access will let me choose a value in the combo box but it doesn't update the other two fields with the corresponding info.

I've tried it using a query and I've tried it working directly from the table and neither works.

What am I missing??

 

[KenReay]

Hi

The combo you are using to do the selecting should be unbound

You need code in the after update event of the combo to read the selected record, do you have that?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[KenReay]

Hi

The code in the after update event will look something like so

Private Sub cboDeliveryAddrId_AfterUpdate()
Dim Rs As Recordset
'
Set Rs = Me.RecordsetClone
Rs.FindFirst "lngDeliveryAddr = " & cboDeliveryAddrId
If Rs.NoMatch Then
Else
Me.Bookmark = Rs.Bookmark
End If
Set Rs = Nothing
End Sub

using your own control names etc

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK