table field values to appear in form text boxes

[Orson9750]

I have asked this question before. BobLarson sent a great example but without coding or SQL query experience my attempts at getting values to appear in a form's text box did not work. I have attached an example of my form and the table of field values that I would like to see populate the form's text boxes for each record.

Thanks! I appreciate your expertise. I will get it I am sure.

 

[jzwp22]

Taking a look at your database, your tables are not normalized. In your table CareOptionTbl, you have repeating groups CareOption1, CareOption2... A care option should be a record in a related field, not as a field (or many fields) in 1 table.

If a facility can have many care options, you have a one-to-many relationship between facility and care options which would require a table structure similar to this:

FacilityCareOptionTbl
-pkFacCareOptID primary key, autonumber
-fkFacilityID foreign key to tblCCLFacilites
-CareOptionsID foreign key to CareOptionsList

I would also recommend that you have a autonumber primary key in your FacilityNameList table rather than using a text field. A text field generally slows down searches.

Also, I was confused why you had your facilities table as well as a redundant facilities listing table.

Also, each facility has various codes associated with it. It might also be best to have these as records in a separate but related table and distinguish by code type.

Also, it is generally recommended not to use spaces or special characters in your table and field names (i.e. ", #, %, ? etc.)

I've cleaned up your database somewhat; it is attached.