Pre-population of fields within a form

[zooyo]

Hey everyone!

I have a question regarding a subform within a form (although I am not so sure this matters but worth sharing). So I have a few fields within the subform that I would like to have pre-populate every time a new record is inserted.

Here is the long and short of it. I work in healthcare and I have a table that that contains Doctors information, the regions they work out of, and it tracks our representative's visits.

I need to have the region they work in pre-populate into the form every time a new record is inserted. Is there anyway to do that?

[orange]

I'm sure there may be a way, but please describe in more detail. It would be helpful if you could give a sample with data of how you see this working. There may be options to get the result you want.

[zooyo]

Sure thing. Here is a sample of what I am working with -

Provider Name Provider ID Date Seen Region
Smith 123456 1/30/14 Mid Atlantic

Within the form there is a button that will insert a new record. Currently it will insert a blank form. I would ideally want this to pre-populate the Provider Name, Provider ID and the Region. And the Date Seen category would be blank to allow for new data to be recorded.

[orange]

I recommend you don't use field names that have embedded spaces or special characters. Use only these chars for field and object names A-Z, 0-9 and _. This will save you a lot of syntax errors.

When you say pre-populate -- where would this list of names/values come from? Are these records from a given table and you are processing all records 1 at a time?
Based on your posts I see a scenario:

The Representative visits the Region to contact Doctors. The whole thing is to create a record indicating this rep saw this Doctor in this Region on DateX.
What tables do you have? What are the designs/fields?

[zooyo]

I have 2 tables. One hold basic information for all the Docs(sheet1) and the other simply is a running list of visits(sheet2). When I created the button to add a new record on the sub form the ID automatically carried over. I don't know how. All I did was create the button to Add Record and the ID carried over but nothing else.

So back to your original question the list of names and values comes from sheet2.

Its hard to explain in too much detail simply because of confidentiality. As sharing any print screens or specific information would result in my termination. I'm almost ready to scrap this idea and try something else. Its something so simple but for whatever reason its borderline impossible to tool around with and figure out. Been looking at this for hours.

[June7]

Subform saves the provider ID because of Master/Child Links properties of the subform container control.

I presume each provider can be associated with only one region.

Don't have a table of Reps?

Do not save provider name and region into Visits, only provider ID.

Options for form data entry/edit.

1. one form bound to Visits with comboboxes to select provider and rep

2. main form bound to Providers and subform bound to Visits with a combobox in subform to select rep

3. main form bound to Reps and subform bound to Visits with a combobox in subform to select provider