By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,166 Members | 1,130 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,166 IT Pros & Developers. It's quick & easy.

AutoForm Code?

P: n/a
If I used the AutoForm button to create a form based on a stored
procedure, where do I find the code or properties that calls the stored
proceedure? Or is this somehow embedded in the form where it's not

I was wanting to edit the popup for the parameter and add some code for
displaying a drop down menu of possible choices for the parameter.

Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies

P: n/a
In the Form properties there is the Datasource property and I think I
need to clear that out and programatically call the query instead.
Does this sound correct?

I'm used to Visual Studio C# where the properties actually generated
eeditable code somewhere, but it doesn't look like setting the
Datasource thing actually generates any code.

Does this sound like I'm understanding correctly?

Nov 13 '05 #2

P: n/a
I got over my initial hurdles, but I've gotten to some more and am
unsure about how to go about this.

I have a data sheet as a subform, and in the main form I have a combo
box above it. Basically I'm going to use the result from the combo box
as a parameter for a stored procedure that I will use to fill the data

I set the Row Source property of the combo box to get distinct vlues
from a particular column so that the user can choose the value that the
stored procedure will filter on. And I need to set the Bound Column
property to this same column, so that when the user selects the value,
then the value of the combo box will be what the user selected,
correct? The problem I'm having is that Bound Column takes a column
number. Is there some sort of function or expression that takes a
column name and evaluates to a column number? I'm afraid if I add
columns in the future then a number will no longer map correctly.

Nov 13 '05 #3

P: n/a
Argh. I don't understand why it wants the primary key to be part of
the Row Source property. All I want is the values populated int he
combo box to be the distinct values from a particular column. This is
anoying me.

Nov 13 '05 #4

P: n/a
Its time to restate your problem, but if it will help, I think I let
the primary key be part of the RowSource --just dont display it by
changing the width of that column to zero.

Nov 13 '05 #5

P: n/a
Sorry, I was just going to let the topic die, as a couple days after I
figured out that I wasn't paying attention to the combobox creation
wizard. The combo box had two columns, and the one I wanted to see was
the hidden one. Just like you said.

I also used the wizard for creating a command button to open a form,
and use the value of the combobox as the filter for the opened
datasheet form. Rather than use a form created from a stored procedure.

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.