i have an unbound form and a vba recordset

[icemonster]

so my question is this:

i have an unbound form that has fields for phone numbers, sometimes the record has more than 1 phone number per client. how do i fill the unbound text boxes on my form when the recordset is filtered for a specific client who has more than 1 phone number?

 

[mdlueck]

sometimes the record has more than 1 phone number per client

Where do the additional phone numbers end up? In an additional column? In an additional DB record?

Not enough information to answer your question.

 

[icemonster]

sorry.

so basically i have a form an unbound one, the reason it's unbound is that my boss requested that we only have to click save once which does add to a point but adds more complexity to what i am doing.

the records are stored as follows

tbl_client
tbl_contact_info (phone numbers, email, etc)
tbl_client_contact_info

when opening a form a vba recordset populates the fields related to the client. now my problem is how to properly populate the phone numbers because most of the times clients have more than one contact number although in the form there are only about 3 fields for phone numbers. my problem when i do this is that when i populate the field only the top record is chosen. how do i set it that it will populate the remaining two fields with the rest of the records?

 

[Pat Hartman]

the reason it's unbound is that my boss requested that we only have to click save once

Access doesn't require you to specifically "save" at all, let alone multiple times. Access automatically saves a record whenever the current record looses focus for what ever reason.

As to the multiple contact numbers problem, you could cheat and use a subform or you can come up with some arbitrary maximum number of contacts and using a code loop fill the controls. Then of course, you need another code loop to update them or write new ones back to the table. Don't forget to handle deletes also.