Thanks for you help, It made me understand what I am trying to do better.
Is there a way to use SQL to retrieve data from a form that is not bound to a table? Maybe I should bind it to the temporary table?
Maybe I'm not approaching this correctly?
The forms purpose is to input funds and...
Could you show me the correct format of SQL in code?? Does it look something like this?? I can't find just a simple example and I'm trying to piece something together. Can you tell me what is wrong? It is giving me an "Expected: End of Statment" error. Maybe i'm not using the...
I have a form that has a couple of combo boxes and text boxes. When the user clicks on the "Add Fund" command button I want the information currently in the boxes to be sent to a temporary table. Can someone tell me how to do this??
Would I just make a normal table and have and sql...
I'm new to this as you can see...So how do you requery??
I'm trying to limit the list box to the social security number that is chosen, so would a requery work?
Thanks for helping - Doug
There are 4 combo boxes and 2 text boxes. I've already started linking the combo boxes. First cbo has only 2 options, which is the type of account.
The second cbo is Fund Family, which are the different mutual fund families.
The third and 4th cbo are linked together and to the 2nd combo...
I want to build a form where you enter in information through a series of linked combo boxes, then the information goes into a list box. The user needs to be able to see the information they just entered in the list box while entering a new record. When they are done entering records there...
yeah the form is named frmName.....old programmer I was working with named it....
I'm still getting all the records in the list box instead of the just the ones that match the SS#
Private Sub cboSelectSS_Change()
Me.lstTSA.RowSource = "SELECT "qryAllocations.Fund_No, qryAllocations.Allocation_Pct,
qryAllocations.SS_No FROM qryAllocations WHERE
(((qryAllocations.SS_No)=[forms]![frmName]!
[cboSelectSS]));
End Sub
gives me a compile error on...
Ok, so now i have this code:
SELECT qryAllocations.Fund_No, qryAllocations.Allocation_Pct, qryAllocations.SS_No
FROM qryAllocations
WHERE (((qryAllocations.SS_No)=[forms]![frmName]![cboSelectSS]));
and i get nothing in the list box now
Thanks for your help so far
opps i think i misread the first post. Are you trying to make it like a menu?? For example the Start button in windows, then you select "All Programs", then you select "Assecories"???
I thought you were just trying to get 2 combo boxes to have the same value.....sorry
I've got a form with 2 combo boxes in the header that controls the tabs in a form. I can use text fields and sub forms and link to the combo boxes, but how do i link a list box???
For example the 2 combo boxes do the samething, just looking up the person by last name or ss#. So in a list box...
There is a much easier way to do this...
Say you have cboSelectname and cboSelectSS, use this on the On Click of cboSelectName
Private Sub cboSelectName_Click()
cboSelectSS.Value = SS_No.Value
End Sub
and this on cboSelectSS
Private Sub cboSelectSS_Click()
cboSelectName.Value =...
I'm using a list box in a report to show 2 columns that vary in length with the number of Funds a customer has. I'm trying to make the list box grow and shrink to these number of funds.
So is a list box my best option??? I have the name of the persons fund in the 1st column and the percentage...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.