Auto Update Form Controls When Another Control is Updated

[blpierce76]

I have a form I use to log in sample with the Lab ID as the tables primary key. Currently I have this form open to the last record for entering new samples. However if I type in or select an existing lab ID I would like the other feilds to auto populate with the data for the lab ID. I have tried a Find Record command button but that gives me an error.

Thanks for any help.

[Rabbit]

If Lab ID is supposed to be the unique primary key, how can you use an existing Lab ID? That's contradictory.

[blpierce76]

I dont want to use an exsiting lab ID. But if I select an exsisting one I would like the other feilds to populate with the data for that one, for editing mistakes etc,.

[BikeToWork]

It sounds like an unbound form. Is that the case? If the form is data-bound, the other fields should also populate when you go to an existing LabID.

[blpierce76]

It does automatically populate the other feilds when I use the nav buttons, but this will not be feasible. I need to be able to type in and/or select the Lab ID and have it do it as well.

[BikeToWork]

Make a combo box with the LabID as the rowsource. Create a procedure for the after_update event on the combo. In the event have the form find the record based on the selection in the combo box. Something like this should work.

Dim RSClone As DAO.Recordset
Dim lngLabID as Long
 
Set RSClone = Me.RecordsetClone
 
If IsNull(Me.cboSearchLabID) Then
    Exit Sub
End If
 
lngLabID= Me. cboSearchLabID
 
RSClone.FindFirst "[ID ]= " & lngLabID
If RSClone.NoMatch = False Then
    Me.Bookmark = RSClone.Bookmark
End If
 
Set RSClone = Nothing
 

[zmbd]

blpierce76:
Hello there, as a chemist I have an idea as to what you might be wanting (^_^)

We need to make sure that your database is normalized. From what I've read so far it may not be, or is not normalized far enough.
Please read thru: > Database Normalization and Table Structures.

[blpierce76]

Bike to Work,

That worked well, but is there a way now that if I enter a new LabID to have the rest of the form go blank, or to a new record?

[blpierce76]

Thanks for that link zmbd.

But unlike you, this chemist may be outta his league with this database stuff. LOL.

Thanks for the help.

[zmbd]

Because we don't know the structure of the database and the form(s) you're using, the answer to your second question is - "more than likely yes."

However, we do try to keep to one topic per thread; thus, please start a new post (or search here on Bytes.com first (^_^) ) Please include a link back to this thread for context if needed.

As for
However, "this chemist may be outta his league" we're not out of your abilities.... there's the minors! ((^_^))

If you need help normalizing the database, please start a new thread. We don't mind helping thru the rough spots; thus, if you show your work, we can maybe provide some guidance to help with the design. I know that I occationally need that help when starting a new database... even if it's just to proof-read the schema!