Pulling data into a form and making it save - microsoft.public.access.formscoding

Okay, on my MainPage form I have two controls (named ManagerSelect and TenureBox) that pull information conditionally from fields in the EMP table. I achieved this by using the DLookUp function as the control source: =DLookUp("[Manager]","[EMP]","ID=" &[EmpName]) for ManagerSelect =DLookUp("[AdjServiceDate]", "[EMP]", "ID=" &[EmpName]) for TenureBox. These values are populating fine, but when I go to save the new record to the database these fields appear blank in the "Records" table I'm saving to. I understand this is happening because the control source on these controls is the formula instead of the bound field in the table as it should be, but I can't find another way to get the correct data to populate. Please Help! Thanks!

One approach might be to bind those controls to their respective fields and use your DLookup function to feed values to them. Would it work to run the DLookup function in code from the form itself, rather than those controls? Perhaps using the OnCurrent event? Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "TheDrescher" <TheDrescher@discussions.microsoft.com> wrote in message news:142E86BA-D9DF-4791-A127-119CAB6C70C1@microsoft.com... > Okay, on my MainPage form I have two controls (named ManagerSelect and > TenureBox) that pull information conditionally from fields in the EMP > table. > I achieved this by using the DLookUp function as the control source: > =DLookUp("[Manager]","[EMP]","ID=" &[EmpName]) for ManagerSelect > =DLookUp("[AdjServiceDate]", "[EMP]", "ID=" &[EmpName]) for TenureBox. > These values are populating fine, but when I go to save the new record to > the database these fields appear blank in the "Records" table I'm saving > to. > I understand this is happening because the control source on these > controls > is the formula instead of the bound field in the table as it should be, > but I > can't find another way to get the correct data to populate. Please Help! > Thanks! >

Jeff, that's a good way to go about it. I originally checked to see if it were possible before I posted. I forgot to mention I'm running Access 2003, I don't seem to have OnCurrent as an event option, thoughts? "Jeff Boyce" wrote: > One approach might be to bind those controls to their respective fields and > use your DLookup function to feed values to them. > > Would it work to run the DLookup function in code from the form itself, > rather than those controls? Perhaps using the OnCurrent event? > > Regards > > Jeff Boyce > Microsoft Access MVP > > -- > Disclaimer: This author may have received products and services mentioned > in this post. Mention and/or description of a product or service herein > does not constitute endorsement thereof. > > Any code or pseudocode included in this post is offered "as is", with no > guarantee as to suitability. > > You can thank the FTC of the USA for making this disclaimer > possible/necessary. > > "TheDrescher" <TheDrescher@discussions.microsoft.com> wrote in message > news:142E86BA-D9DF-4791-A127-119CAB6C70C1@microsoft.com... > > Okay, on my MainPage form I have two controls (named ManagerSelect and > > TenureBox) that pull information conditionally from fields in the EMP > > table. > > I achieved this by using the DLookUp function as the control source: > > =DLookUp("[Manager]","[EMP]","ID=" &[EmpName]) for ManagerSelect > > =DLookUp("[AdjServiceDate]", "[EMP]", "ID=" &[EmpName]) for TenureBox. > > These values are populating fine, but when I go to save the new record to > > the database these fields appear blank in the "Records" table I'm saving > > to. > > I understand this is happening because the control source on these > > controls > > is the formula instead of the bound field in the table as it should be, > > but I > > can't find another way to get the correct data to populate. Please Help! > > Thanks! > > > > > . >

Open the form in design view. Check the events ... I'm pretty sure A03 has the OnCurrent event, that triggers when a (new) record is loaded into the form. Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "TheDrescher" <TheDrescher@discussions.microsoft.com> wrote in message news:3C3F63D6-F6A2-454C-8D5D-03B75B207C5F@microsoft.com... > Jeff, that's a good way to go about it. I originally checked to see if it > were possible before I posted. I forgot to mention I'm running Access > 2003, > I don't seem to have OnCurrent as an event option, thoughts? > > "Jeff Boyce" wrote: > >> One approach might be to bind those controls to their respective fields >> and >> use your DLookup function to feed values to them. >> >> Would it work to run the DLookup function in code from the form itself, >> rather than those controls? Perhaps using the OnCurrent event? >> >> Regards >> >> Jeff Boyce >> Microsoft Access MVP >> >> -- >> Disclaimer: This author may have received products and services mentioned >> in this post. Mention and/or description of a product or service herein >> does not constitute endorsement thereof. >> >> Any code or pseudocode included in this post is offered "as is", with no >> guarantee as to suitability. >> >> You can thank the FTC of the USA for making this disclaimer >> possible/necessary. >> >> "TheDrescher" <TheDrescher@discussions.microsoft.com> wrote in message >> news:142E86BA-D9DF-4791-A127-119CAB6C70C1@microsoft.com... >> > Okay, on my MainPage form I have two controls (named ManagerSelect and >> > TenureBox) that pull information conditionally from fields in the EMP >> > table. >> > I achieved this by using the DLookUp function as the control source: >> > =DLookUp("[Manager]","[EMP]","ID=" &[EmpName]) for ManagerSelect >> > =DLookUp("[AdjServiceDate]", "[EMP]", "ID=" &[EmpName]) for TenureBox. >> > These values are populating fine, but when I go to save the new record >> > to >> > the database these fields appear blank in the "Records" table I'm >> > saving >> > to. >> > I understand this is happening because the control source on these >> > controls >> > is the formula instead of the bound field in the table as it should be, >> > but I >> > can't find another way to get the correct data to populate. Please >> > Help! >> > Thanks! >> > >> >> >> . >>

Jeff, The original control for this was simply a text box, because you really don't need to select anything after the code pulls up the name. Is this the best way or should I utilize something else? Thanks! "Jeff Boyce" wrote: > One approach might be to bind those controls to their respective fields and > use your DLookup function to feed values to them. > > Would it work to run the DLookup function in code from the form itself, > rather than those controls? Perhaps using the OnCurrent event? > > Regards > > Jeff Boyce > Microsoft Access MVP > > -- > Disclaimer: This author may have received products and services mentioned > in this post. Mention and/or description of a product or service herein > does not constitute endorsement thereof. > > Any code or pseudocode included in this post is offered "as is", with no > guarantee as to suitability. > > You can thank the FTC of the USA for making this disclaimer > possible/necessary. > > "TheDrescher" <TheDrescher@discussions.microsoft.com> wrote in message > news:142E86BA-D9DF-4791-A127-119CAB6C70C1@microsoft.com... > > Okay, on my MainPage form I have two controls (named ManagerSelect and > > TenureBox) that pull information conditionally from fields in the EMP > > table. > > I achieved this by using the DLookUp function as the control source: > > =DLookUp("[Manager]","[EMP]","ID=" &[EmpName]) for ManagerSelect > > =DLookUp("[AdjServiceDate]", "[EMP]", "ID=" &[EmpName]) for TenureBox. > > These values are populating fine, but when I go to save the new record to > > the database these fields appear blank in the "Records" table I'm saving > > to. > > I understand this is happening because the control source on these > > controls > > is the formula instead of the bound field in the table as it should be, > > but I > > can't find another way to get the correct data to populate. Please Help! > > Thanks! > > > > > . >

Wouldn't that depend on what the underlying data is? You've already identified that it is for display only, right? Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "TheDrescher" <TheDrescher@discussions.microsoft.com> wrote in message news:B1FCDA95-D20D-4227-960E-7599DCA19CD2@microsoft.com... > Jeff, > > The original control for this was simply a text box, because you really > don't need to select anything after the code pulls up the name. Is this > the > best way or should I utilize something else? Thanks! > > "Jeff Boyce" wrote: > >> One approach might be to bind those controls to their respective fields >> and >> use your DLookup function to feed values to them. >> >> Would it work to run the DLookup function in code from the form itself, >> rather than those controls? Perhaps using the OnCurrent event? >> >> Regards >> >> Jeff Boyce >> Microsoft Access MVP >> >> -- >> Disclaimer: This author may have received products and services mentioned >> in this post. Mention and/or description of a product or service herein >> does not constitute endorsement thereof. >> >> Any code or pseudocode included in this post is offered "as is", with no >> guarantee as to suitability. >> >> You can thank the FTC of the USA for making this disclaimer >> possible/necessary. >> >> "TheDrescher" <TheDrescher@discussions.microsoft.com> wrote in message >> news:142E86BA-D9DF-4791-A127-119CAB6C70C1@microsoft.com... >> > Okay, on my MainPage form I have two controls (named ManagerSelect and >> > TenureBox) that pull information conditionally from fields in the EMP >> > table. >> > I achieved this by using the DLookUp function as the control source: >> > =DLookUp("[Manager]","[EMP]","ID=" &[EmpName]) for ManagerSelect >> > =DLookUp("[AdjServiceDate]", "[EMP]", "ID=" &[EmpName]) for TenureBox. >> > These values are populating fine, but when I go to save the new record >> > to >> > the database these fields appear blank in the "Records" table I'm >> > saving >> > to. >> > I understand this is happening because the control source on these >> > controls >> > is the formula instead of the bound field in the table as it should be, >> > but I >> > can't find another way to get the correct data to populate. Please >> > Help! >> > Thanks! >> > >> >> >> . >>

Jeff, Under the events tab of the properties for that control, there doesn't seem to be an OnCurrent event listed, I populated all events relating to that control (with the exception of the mouse moves and key presses) with the code I mentioned previously: =DLookUp("[Manager]","[EMP]","ID=" &[EmpName]). Returning to Form View it now simply shows a drop down menu containing all the manager names instead of the one assigned to the particular employee. "Jeff Boyce" wrote: > Open the form in design view. Check the events ... I'm pretty sure A03 has > the OnCurrent event, that triggers when a (new) record is loaded into the > form. > > Regards > > Jeff Boyce > Microsoft Access MVP > > -- > Disclaimer: This author may have received products and services mentioned > in this post. Mention and/or description of a product or service herein > does not constitute endorsement thereof. > > Any code or pseudocode included in this post is offered "as is", with no > guarantee as to suitability. > > You can thank the FTC of the USA for making this disclaimer > possible/necessary. > > "TheDrescher" <TheDrescher@discussions.microsoft.com> wrote in message > news:3C3F63D6-F6A2-454C-8D5D-03B75B207C5F@microsoft.com... > > Jeff, that's a good way to go about it. I originally checked to see if it > > were possible before I posted. I forgot to mention I'm running Access > > 2003, > > I don't seem to have OnCurrent as an event option, thoughts? > > > > "Jeff Boyce" wrote: > > > >> One approach might be to bind those controls to their respective fields > >> and > >> use your DLookup function to feed values to them. > >> > >> Would it work to run the DLookup function in code from the form itself, > >> rather than those controls? Perhaps using the OnCurrent event? > >> > >> Regards > >> > >> Jeff Boyce > >> Microsoft Access MVP > >> > >> -- > >> Disclaimer: This author may have received products and services mentioned > >> in this post. Mention and/or description of a product or service herein > >> does not constitute endorsement thereof. > >> > >> Any code or pseudocode included in this post is offered "as is", with no > >> guarantee as to suitability. > >> > >> You can thank the FTC of the USA for making this disclaimer > >> possible/necessary. > >> > >> "TheDrescher" <TheDrescher@discussions.microsoft.com> wrote in message > >> news:142E86BA-D9DF-4791-A127-119CAB6C70C1@microsoft.com... > >> > Okay, on my MainPage form I have two controls (named ManagerSelect and > >> > TenureBox) that pull information conditionally from fields in the EMP > >> > table. > >> > I achieved this by using the DLookUp function as the control source: > >> > =DLookUp("[Manager]","[EMP]","ID=" &[EmpName]) for ManagerSelect > >> > =DLookUp("[AdjServiceDate]", "[EMP]", "ID=" &[EmpName]) for TenureBox. > >> > These values are populating fine, but when I go to save the new record > >> > to > >> > the database these fields appear blank in the "Records" table I'm > >> > saving > >> > to. > >> > I understand this is happening because the control source on these > >> > controls > >> > is the formula instead of the bound field in the table as it should be, > >> > but I > >> > can't find another way to get the correct data to populate. Please > >> > Help! > >> > Thanks! > >> > > >> > >> > >> . > >> > > > . >

That's correct, the whole point is that the person filling out the database won't have to go anywhere to look up the employee's manager; it simply auto-populates. If I add the code into a text box as the control source, it was pulling the data correctly, but then when I'd go to save to a table, it would just populate a null field in the table itself, I'd like the text that was displayed to save to the table like the rest of the form data. "Jeff Boyce" wrote: > Wouldn't that depend on what the underlying data is? You've already > identified that it is for display only, right? > > Regards > > Jeff Boyce > Microsoft Access MVP > > -- > Disclaimer: This author may have received products and services mentioned > in this post. Mention and/or description of a product or service herein > does not constitute endorsement thereof. > > Any code or pseudocode included in this post is offered "as is", with no > guarantee as to suitability. > > You can thank the FTC of the USA for making this disclaimer > possible/necessary. > > "TheDrescher" <TheDrescher@discussions.microsoft.com> wrote in message > news:B1FCDA95-D20D-4227-960E-7599DCA19CD2@microsoft.com... > > Jeff, > > > > The original control for this was simply a text box, because you really > > don't need to select anything after the code pulls up the name. Is this > > the > > best way or should I utilize something else? Thanks! > > > > "Jeff Boyce" wrote: > > > >> One approach might be to bind those controls to their respective fields > >> and > >> use your DLookup function to feed values to them. > >> > >> Would it work to run the DLookup function in code from the form itself, > >> rather than those controls? Perhaps using the OnCurrent event? > >> > >> Regards > >> > >> Jeff Boyce > >> Microsoft Access MVP > >> > >> -- > >> Disclaimer: This author may have received products and services mentioned > >> in this post. Mention and/or description of a product or service herein > >> does not constitute endorsement thereof. > >> > >> Any code or pseudocode included in this post is offered "as is", with no > >> guarantee as to suitability. > >> > >> You can thank the FTC of the USA for making this disclaimer > >> possible/necessary. > >> > >> "TheDrescher" <TheDrescher@discussions.microsoft.com> wrote in message > >> news:142E86BA-D9DF-4791-A127-119CAB6C70C1@microsoft.com... > >> > Okay, on my MainPage form I have two controls (named ManagerSelect and > >> > TenureBox) that pull information conditionally from fields in the EMP > >> > table. > >> > I achieved this by using the DLookUp function as the control source: > >> > =DLookUp("[Manager]","[EMP]","ID=" &[EmpName]) for ManagerSelect > >> > =DLookUp("[AdjServiceDate]", "[EMP]", "ID=" &[EmpName]) for TenureBox. > >> > These values are populating fine, but when I go to save the new record > >> > to > >> > the database these fields appear blank in the "Records" table I'm > >> > saving > >> > to. > >> > I understand this is happening because the control source on these > >> > controls > >> > is the formula instead of the bound field in the table as it should be, > >> > but I > >> > can't find another way to get the correct data to populate. Please > >> > Help! > >> > Thanks! > >> > > >> > >> > >> . > >> > > > . >

Similiar Articles:

how to pull a record to a form and save it to another table ...
How to pull data from website into my table ? - microsoft.public ... how to pull a record to a form and save it to another table ... You can use an INSERT INTO query: Dim ...

How to pull data from one table and save it to another - microsoft ...
How to pull data from website into my table ? - microsoft.public ... public.access how to pull a record to a form and save it to another table ... How to pull data from ...

Save Query Results as table to another Access Database - microsoft ...
... should do it for you: SELECT * INTO ... Save form data to table - microsoft.public.access ... How to pull data from one table and save it to another - microsoft ...

How to pull data from website into my table ? - microsoft.public ...
how to pull a record to a form and save it to another table ... How to pull data from website into my table ? - microsoft.public ... how to pull a record to a form and ...

Save form data to table - microsoft.public.access.forms ...
how to pull a record to a form and save it to another table ... hi, I want to pull data ... off a query and I want to print this form and then save the data on the form into ...

How to pull tables in from SQL then push data back to SQL ...
I have queries in Access that pull in data from an SQL back end. I have a form that has ... But then ... Save listbox data to SQl table... data into SQL table.

Creating a table into another Access database - microsoft.public ...
How Write New Field Data From Form Entry Into A Separate Table ..... Entry Into ... How to pull data from one table and save it to another - microsoft ... You can bring data ...

Save New Record from Form - microsoft.public.access
Save data entered into a form - microsoft.public.access.forms ... how to pull a record to a form and save it to another table ... How to pull data from one table and save it ...

Automatically pull data from one file to populate a template ...
Needs help to pull data from excel file and put it into new excel ... ... file, applies the filter , save the ... Pulling data from ... multiple Word files into one form ...

copying a whole record from one table to another - microsoft ...
I have a make table query that pulls data from this databae and puts it into a table in ... ... how to pull a record to a form and save it to another table ... ...

How to Extract PDF Form Data | eHow.com
Click the "Save in" menu to access a folder in which to save the PDF form data. Type a name for the Form Data File into the "File name" field and click the "Save" button.

How to Save Dreamweaver Web Form Data Into a Database | eHow.com
A Web form is a way to gather information from your visitors, and it only requires a small amount of HTML (Hypertext Markup Language) code to create a Web form with ...

Saving Word Form Data for Use in Excel - How to Use Microsoft Word ...
... data from your Word forms into Excel. It ... some reason, Microsoft doesn’t make it easy for users to extract their form data ... Select Save data only for forms; Open the Save ...

Exporting Word Form Data - Computor Companion - Smart Ideas and ...
Either way, importing your form data into Excel or Access from Word will save you from having to retype the data manually and will help to ensure a more accurate data ...

Pulling CRM Data into InfoPath 2007 Browser Forms
... Office InfoPath 2007 allows you to pull data from different back-end sources (for example, a CRM database) into form files ... Click the Save icon on the toolbar. In the Save ...

7/28/2012 8:43:13 PM