Computing.Net > Forums > Office Software > MS Access

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

MS Access

Reply to Message Icon

Name: gen13
Date: May 25, 2005 at 14:42:35 Pacific
OS: Windows 2000
CPU/Ram: P4 3GHz 512MB
Comment:

I have a form that is based on a stored procedure. How do I pass parameter values from a combo box to the stored procedure? In other words, how do I input data into the combo box so that I can save it into the table it gets its data from, rather than tediously going into the table itself and inputting the data?
Thanks in advance.



Sponsored Link
Ads by Google

Response Number 1
Name: mdow
Date: May 26, 2005 at 05:37:48 Pacific
Reply:

I'm not sure I understand what your doing. You state "I have a form that is based on a stored procedure." What is a Stored Procedure? A form's data source can be either a table or a query. Is your stored procedure a query?

Also, you state "so that I can save it into the table it gets its data from." What does "it" refer to. Is "it" the value in your combobox? Generally, a combobox is used to look up a range of values based on a query. For example, you might have a combobox that lists all your customers. If you want to add a new customer (not in the list), then you would add the customer using the customer form. Not the combobox.

If you want to insert a record into a table based on the selection you chose from the combobox, then you either have the form's data source = to that table or you use an action query in one of the forms or controls events. For example you can use the After Update event to run a query.



0

Response Number 2
Name: gen13
Date: May 26, 2005 at 06:58:37 Pacific
Reply:

The form's data source is a table. "It" is the value in the combo box that I want to save in the table. While it is true the combo box's primary function is to look up a range of values, I did manage to store a value into the table used as the data source. Perhaps it was a fluke, but nonetheless, the value was stored as were the other values for the other fields that I entered information for. My problem is trying to replicate it...permanently.


0

Response Number 3
Name: mdow
Date: May 26, 2005 at 07:39:28 Pacific
Reply:

Ok I think I understand what you are doing. In the properties of the combo box, look for the control source property. You should be able to select the field form your table that you want to store the data in. Make sure the bound column is the correct column of data you wish to record.

Once a new record is entered in your form the value in your combo box will save as well.


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: MS Access

optimising MS Access files www.computing.net/answers/office/optimising-ms-access-files/1760.html

Ms Access Querry www.computing.net/answers/office/ms-access-querry/2771.html

MS Access 97 SQL Minus Queries www.computing.net/answers/office/ms-access-97-sql-minus-queries/702.html