If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combo Box to find a record they display on a form
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? |
#2
|
|||
|
|||
Combo Box to find a record they display on a form
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 wrote: 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 (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 http://www.accessmonster.com/Uwe/For...forms/200903/1 |
#3
|
|||
|
|||
Combo Box to find a record they display on a form
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" wrote: 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 wrote: 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 (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 http://www.accessmonster.com/Uwe/For...forms/200903/1 |
#4
|
|||
|
|||
Combo Box to find a record they display on a form
Are all of your Form Controls bound to fields in the underlying RecordSource?
Did you select Option 3 when you created the ComboBox? Debi wrote: 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 (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 http://www.accessmonster.com |
#5
|
|||
|
|||
Combo Box to find a record they display on a form
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. "ruralguy via AccessMonster.com" wrote: Are all of your Form Controls bound to fields in the underlying RecordSource? Did you select Option 3 when you created the ComboBox? Debi wrote: 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 (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 http://www.accessmonster.com |
#6
|
|||
|
|||
Combo Box to find a record they display on a form
Try option 3. You'll like it.
Debi wrote: 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 http://www.accessmonster.com/Uwe/For...forms/200903/1 |
#7
|
|||
|
|||
Combo Box to find a record they display on a form
I did but it still doesn't populate all the fields on the form.... I know I
am missing something simple "ruralguy via AccessMonster.com" wrote: Try option 3. You'll like it. Debi wrote: 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 http://www.accessmonster.com/Uwe/For...forms/200903/1 |
#8
|
|||
|
|||
Combo Box to find a record they display on a form
Turn on the NavButtons on the bottom of the form and move to different
records. Do all of the "Fields" on the form populate? Debi wrote: 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] 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 http://www.accessmonster.com/Uwe/For...forms/200903/1 |
#9
|
|||
|
|||
Combo Box to find a record they display on a form
On Mon, 2 Mar 2009 08:55:02 -0800, Debi
wrote: 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? -- John W. Vinson [MVP] |
#10
|
|||
|
|||
Combo Box to find a record they display on a form
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... "John W. Vinson" wrote: On Mon, 2 Mar 2009 08:55:02 -0800, Debi wrote: 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? -- John W. Vinson [MVP] |
|
Thread Tools | |
Display Modes | |
|
|