Combo Box to find a record they display on a form

[Debi]

I haven't worked in Access in over 10 years and am having trouble getting my
form to work properly. I have a form that will display all fields on a table
by finding a record in a combo box. My problem is when I like on the record
I want to display for edits not all the fields are getting propulated. What
step am I missing here?

 

[ruralguy via AccessMonster.com]

Hi Debi,

How are you getting to the "record you want to edit"? Did you let the widard
create the form for you? Are you using a wizard created ComboBox to "find the
record" or do you navigate using the Nav Buttons on the bottom of the form?
What version of Access are you using?

 

[Debi]

Hey there.... I did use the wizzard to create the combo box, but created the
form myself. I am using Access 2003 SP2. I feel really rusty in Access :/

 

[ruralguy via AccessMonster.com]

Are all of your Form Controls bound to fields in the underlying RecordSource?
Did you select Option 3 when you created the ComboBox?

Hey there.... I did use the wizzard to create the combo box, but created the
form myself. I am using Access 2003 SP2. I feel really rusty in Access :/

Hi Debi,

[quoted text clipped - 8 lines]

 

[Debi]

No I picked option 1.... when the user clicks on the record they want I want
the whole form to populate so she can add or edit.

Are all of your Form Controls bound to fields in the underlying RecordSource?
Did you select Option 3 when you created the ComboBox?

Hey there.... I did use the wizzard to create the combo box, but created the
form myself. I am using Access 2003 SP2. I feel really rusty in Access :/

Hi Debi,

[quoted text clipped - 8 lines]

I want to display for edits not all the fields are getting propulated. What
step am I missing here?

 

[ruralguy via AccessMonster.com]

Try option 3. You'll like it.

No I picked option 1.... when the user clicks on the record they want I want
the whole form to populate so she can add or edit.

Are all of your Form Controls bound to fields in the underlying RecordSource?
Did you select Option 3 when you created the ComboBox?

[quoted text clipped - 7 lines]

 

[Debi]

I did but it still doesn't populate all the fields on the form.... I know I
am missing something simple

Try option 3. You'll like it.

No I picked option 1.... when the user clicks on the record they want I want
the whole form to populate so she can add or edit.

Are all of your Form Controls bound to fields in the underlying RecordSource?
Did you select Option 3 when you created the ComboBox?

[quoted text clipped - 7 lines]

I want to display for edits not all the fields are getting propulated. What
step am I missing here?

 

[ruralguy via AccessMonster.com]

Turn on the NavButtons on the bottom of the form and move to different
records. Do all of the "Fields" on the form populate?

I did but it still doesn't populate all the fields on the form.... I know I
am missing something simple

Try option 3. You'll like it.

[quoted text clipped - 6 lines]

 

[John W. Vinson]

I did but it still doesn't populate all the fields on the form.... I know I
am missing something simple

What is the "Record Source" property of the form (it should be either the name
of your table or, better, a Query based on the table containing all the fields
you want to see)? What are the Control Source properties of the textboxes
which aren't populating (should be the fieldnames)? If you open the table
datasheet directly do you see the data you expect?

 

[Debi]

I have tried it based on a query and also direct for the table to populate.
When I built the form I used the field list and yes the data is there...

 

[Debi]

In the form properties I have it set to Yes for Data Entry... but on my event
procedure after update.... is where I am having a problem setting it to
display all the fields that have been entered on the table. So like after
you use the combo box to search a person and you click on in it then I want
the rest of the form to populate.... am I making sense?

 

[ruralguy via AccessMonster.com]

When you set DataEntry to YES the form will *only* display new records.
I assume you are aware of that. You can also display a new record when
DataEntry is set to NO.

In the form properties I have it set to Yes for Data Entry... but on my event
procedure after update.... is where I am having a problem setting it to
display all the fields that have been entered on the table. So like after
you use the combo box to search a person and you click on in it then I want
the rest of the form to populate.... am I making sense?
[quoted text clipped - 4 lines]

which aren't populating (should be the fieldnames)? If you open the table
datasheet directly do you see the data you expect?

 

[John W. Vinson]

I have it set to Yes for Data Entry.

That's the problem. Set it to No. Data entry means you want the form to ONLY
let you add new records, not see existing ones.