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
|
|||
|
|||
Update text box based on data in combo box
I have searched for my specific issue but did not find any responses. I
found several "close" ones and tried to manipulate the responses to fit my issue, no luck! I have tblFiles on which frmProjectFiles is based. I have a make table query qryProjects which groups "Project Name", "Project Number", and "Project Manager" from entries in tblFiles and then creates tblProject. I would like to on frmProjectFiles to be able to select a "Project Name" and the "Project Number" and "Project Manager" would be auto entered. I also need users to be able to enter new information for each field as new projects are created. I have tried to manipulate the AfterUpdate property of "Project Name" to fill in the text boxes, but could not get any configuration I could think of to work. I have tried Dlookup in the control source of "Project Number" and "Project Manager" but get a "circular reference" error. When I set the column value of "Project Name" to three and then reference the correct column for each "Project Number" and "Project Manager", it does not populate the table for new entries. The more I search in this discussion group the more I am confussed. Right now, I have no code and all three controls are text boxes. This causes data entry to be done every time, even if it is a new file for a current project, which causes spelling errors. The data in these three controls needs to be consistent throughout all entries for the same project. Any ideas? Ember |
#2
|
|||
|
|||
Update text box based on data in combo box
See this article at The ACCESS Web:
http://www.mvps.org/access/forms/frm0058.htm -- Ken Snell MS ACCESS MVP "Ember" wrote in message ... I have searched for my specific issue but did not find any responses. I found several "close" ones and tried to manipulate the responses to fit my issue, no luck! I have tblFiles on which frmProjectFiles is based. I have a make table query qryProjects which groups "Project Name", "Project Number", and "Project Manager" from entries in tblFiles and then creates tblProject. I would like to on frmProjectFiles to be able to select a "Project Name" and the "Project Number" and "Project Manager" would be auto entered. I also need users to be able to enter new information for each field as new projects are created. I have tried to manipulate the AfterUpdate property of "Project Name" to fill in the text boxes, but could not get any configuration I could think of to work. I have tried Dlookup in the control source of "Project Number" and "Project Manager" but get a "circular reference" error. When I set the column value of "Project Name" to three and then reference the correct column for each "Project Number" and "Project Manager", it does not populate the table for new entries. The more I search in this discussion group the more I am confussed. Right now, I have no code and all three controls are text boxes. This causes data entry to be done every time, even if it is a new file for a current project, which causes spelling errors. The data in these three controls needs to be consistent throughout all entries for the same project. Any ideas? Ember |
#3
|
|||
|
|||
Update text box based on data in combo box
Thank you Ken...I had done it backwards where I used the unbound solution as
VBA code and the VBA code in the control source. One more thing...could you please tell me (in the bound solution) if I still use "Me." and ".Value" or do I need to use my own wording. Thanks! "Ken Snell (MVP)" wrote: See this article at The ACCESS Web: http://www.mvps.org/access/forms/frm0058.htm -- Ken Snell MS ACCESS MVP "Ember" wrote in message ... I have searched for my specific issue but did not find any responses. I found several "close" ones and tried to manipulate the responses to fit my issue, no luck! I have tblFiles on which frmProjectFiles is based. I have a make table query qryProjects which groups "Project Name", "Project Number", and "Project Manager" from entries in tblFiles and then creates tblProject. I would like to on frmProjectFiles to be able to select a "Project Name" and the "Project Number" and "Project Manager" would be auto entered. I also need users to be able to enter new information for each field as new projects are created. I have tried to manipulate the AfterUpdate property of "Project Name" to fill in the text boxes, but could not get any configuration I could think of to work. I have tried Dlookup in the control source of "Project Number" and "Project Manager" but get a "circular reference" error. When I set the column value of "Project Name" to three and then reference the correct column for each "Project Number" and "Project Manager", it does not populate the table for new entries. The more I search in this discussion group the more I am confussed. Right now, I have no code and all three controls are text boxes. This causes data entry to be done every time, even if it is a new file for a current project, which causes spelling errors. The data in these three controls needs to be consistent throughout all entries for the same project. Any ideas? Ember |
#4
|
|||
|
|||
Update text box based on data in combo box
Me and Value are to be used as is.
Me is a "built-in" object in VBA that means the object to which the module belongs. Value is a property of a control. -- Ken Snell MS ACCESS MVP "Ember" wrote in message ... Thank you Ken...I had done it backwards where I used the unbound solution as VBA code and the VBA code in the control source. One more thing...could you please tell me (in the bound solution) if I still use "Me." and ".Value" or do I need to use my own wording. Thanks! "Ken Snell (MVP)" wrote: See this article at The ACCESS Web: http://www.mvps.org/access/forms/frm0058.htm -- Ken Snell MS ACCESS MVP "Ember" wrote in message ... I have searched for my specific issue but did not find any responses. I found several "close" ones and tried to manipulate the responses to fit my issue, no luck! I have tblFiles on which frmProjectFiles is based. I have a make table query qryProjects which groups "Project Name", "Project Number", and "Project Manager" from entries in tblFiles and then creates tblProject. I would like to on frmProjectFiles to be able to select a "Project Name" and the "Project Number" and "Project Manager" would be auto entered. I also need users to be able to enter new information for each field as new projects are created. I have tried to manipulate the AfterUpdate property of "Project Name" to fill in the text boxes, but could not get any configuration I could think of to work. I have tried Dlookup in the control source of "Project Number" and "Project Manager" but get a "circular reference" error. When I set the column value of "Project Name" to three and then reference the correct column for each "Project Number" and "Project Manager", it does not populate the table for new entries. The more I search in this discussion group the more I am confussed. Right now, I have no code and all three controls are text boxes. This causes data entry to be done every time, even if it is a new file for a current project, which causes spelling errors. The data in these three controls needs to be consistent throughout all entries for the same project. Any ideas? Ember |
#5
|
|||
|
|||
Update text box based on data in combo box
Again, thank you!
Ember "Ken Snell (MVP)" wrote: Me and Value are to be used as is. Me is a "built-in" object in VBA that means the object to which the module belongs. Value is a property of a control. -- Ken Snell MS ACCESS MVP "Ember" wrote in message ... Thank you Ken...I had done it backwards where I used the unbound solution as VBA code and the VBA code in the control source. One more thing...could you please tell me (in the bound solution) if I still use "Me." and ".Value" or do I need to use my own wording. Thanks! "Ken Snell (MVP)" wrote: See this article at The ACCESS Web: http://www.mvps.org/access/forms/frm0058.htm -- Ken Snell MS ACCESS MVP "Ember" wrote in message ... I have searched for my specific issue but did not find any responses. I found several "close" ones and tried to manipulate the responses to fit my issue, no luck! I have tblFiles on which frmProjectFiles is based. I have a make table query qryProjects which groups "Project Name", "Project Number", and "Project Manager" from entries in tblFiles and then creates tblProject. I would like to on frmProjectFiles to be able to select a "Project Name" and the "Project Number" and "Project Manager" would be auto entered. I also need users to be able to enter new information for each field as new projects are created. I have tried to manipulate the AfterUpdate property of "Project Name" to fill in the text boxes, but could not get any configuration I could think of to work. I have tried Dlookup in the control source of "Project Number" and "Project Manager" but get a "circular reference" error. When I set the column value of "Project Name" to three and then reference the correct column for each "Project Number" and "Project Manager", it does not populate the table for new entries. The more I search in this discussion group the more I am confussed. Right now, I have no code and all three controls are text boxes. This causes data entry to be done every time, even if it is a new file for a current project, which causes spelling errors. The data in these three controls needs to be consistent throughout all entries for the same project. Any ideas? Ember |
Thread Tools | |
Display Modes | |
|
|