2 doubts
- Thread starter cnuhima
- Start date
Hi,
If i write the above one its not accepting it and showing a Msgbox with
The syntax of the subquery in this expression is incorrect and check the syntax of the subquery and enclose it in paranthesis..
If i give in the below manner it would not show any error but gives me #name? when i run the form..
=(SELECT [FullName]
FROM [Order]
WHERE
([OrderNo]=([Forms]![Quotation].OrderNumber)))
Thank u very much
If i write the above one its not accepting it and showing a Msgbox with
The syntax of the subquery in this expression is incorrect and check the syntax of the subquery and enclose it in paranthesis..
If i give in the below manner it would not show any error but gives me #name? when i run the form..
=(SELECT [FullName]
FROM [Order]
WHERE
([OrderNo]=([Forms]![Quotation].OrderNumber)))
Thank u very much
MSAccessRookie
AWF VIP
- Local time
- Yesterday, 23:14
- Joined
- May 2, 2008
- Messages
- 3,428
I have noticed that Quotation has been spelled in different ways. Check the actual NAME of the control and compare it to the query to Verify that there is not a msispelling
Can you post an example of the DB?
in the first combo box, Can't you use the wizard and type in the default values you want?
The second combo box: Why can't you create a query and in the criteria part of click on Expression and map to the form and fields you want from the combo box? On the form you will have to have the fields that you want populate, which I assume is based on a table or query.
This doesn't seem like it should be that difficult if you use the wizard.
I am novice at this too, but that is how I create it on my forms.
Larry
in the first combo box, Can't you use the wizard and type in the default values you want?
The second combo box: Why can't you create a query and in the criteria part of click on Expression and map to the form and fields you want from the combo box? On the form you will have to have the fields that you want populate, which I assume is based on a table or query.
This doesn't seem like it should be that difficult if you use the wizard.
I am novice at this too, but that is how I create it on my forms.
Larry
Hi
I have 2 Doubts
(1) I have a combo box in the Orders form.The combo box contains list of the material names such as iron,paper etc.i manually typed all the values in the combo box.
But now my problem is that when i load the form it is not showing any value .so i want the default item as "select item" which can be viewed on the combo box before the user selects the option
(2) My other doubt was I have a Quotation in which I have a combo box which contains all the orders numbers(which are loaded from the orders table).The user after selecting the particular order number,i want the textboxes of the name and address to be filled automatically according to that particular order number..
for that to happen i wrote a query in the expression bulider of the name textbox as
=(SELECT [FullName] FROM [Order] WHERE ([OrderNo]=([Forms]![Quoatation.OrderNumber])))
but its giving #name?
Please help me out
Thank U
I have 2 Doubts
(1) I have a combo box in the Orders form.The combo box contains list of the material names such as iron,paper etc.i manually typed all the values in the combo box.
But now my problem is that when i load the form it is not showing any value .so i want the default item as "select item" which can be viewed on the combo box before the user selects the option
(2) My other doubt was I have a Quotation in which I have a combo box which contains all the orders numbers(which are loaded from the orders table).The user after selecting the particular order number,i want the textboxes of the name and address to be filled automatically according to that particular order number..
for that to happen i wrote a query in the expression bulider of the name textbox as
=(SELECT [FullName] FROM [Order] WHERE ([OrderNo]=([Forms]![Quoatation.OrderNumber])))
but its giving #name?
Please help me out
Thank U
Sample DB
Okay...I just threw this together and I think this may help put you on the right track... I think.
Take a look at what I did and how I have the combo boxes looking at the queries, instead of "writing" the queries in the expression box.
Larry
Okay...I just threw this together and I think this may help put you on the right track... I think.
Take a look at what I did and how I have the combo boxes looking at the queries, instead of "writing" the queries in the expression box.
Larry
hi guys ,
I got the solution.
Here is the code..
Private Sub Combo7_LostFocus()
Dim db1 As DAO.Database
Dim rs1 As DAO.Recordset
Dim VbMsgBoxResult As Integer
Dim varPOBaseNumber As String
Dim intPONumber As Integer
Set db1 = CurrentDb()
Set rs1 = db1.OpenRecordset("SELECT name FROM Table1 WHERE orderno = " & Combo7.Value & " ", dbOpenSnapshot)
'Do Until rs1.EOF
'rs1.Delete
'rs1.Move 1
'Loop
Text9.Value = rs1(0)
db1.Close
Set db1 = Nothing
'rs1.Close
Set rs1 = Nothing
End Sub
Thank u very much guys
I got the solution.
Here is the code..
Private Sub Combo7_LostFocus()
Dim db1 As DAO.Database
Dim rs1 As DAO.Recordset
Dim VbMsgBoxResult As Integer
Dim varPOBaseNumber As String
Dim intPONumber As Integer
Set db1 = CurrentDb()
Set rs1 = db1.OpenRecordset("SELECT name FROM Table1 WHERE orderno = " & Combo7.Value & " ", dbOpenSnapshot)
'Do Until rs1.EOF
'rs1.Delete
'rs1.Move 1
'Loop
Text9.Value = rs1(0)
db1.Close
Set db1 = Nothing
'rs1.Close
Set rs1 = Nothing
End Sub
Thank u very much guys
Similar threads
