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?

 

[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 :/

 

[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?

 

[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 (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com

 

[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?

 

[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.