Sql String Help Pls

[kiddz7]

sqlstring = sqlstring & "from booking where booking.bookingid = bookingid"

whats wrong with that select statement?
when i run it,it suppose to give me fields for specific booking id, but it shows specific fields for all booking

need help pls

[Joacim Andersson]

I would need to see the whole SQL statement to be able to answer that.

[kiddz7]

dim bookingid as integer

lstbookingid = bookingid
'lstbookingid is a listbox

select bookingdate from booking where bookingid = bookingid

[Lethal]

Try this:

bookingid = lstbookingid.List(lstbookingid.ListIndex)

You also may have to convert bookingid to the correct data type,
depending upon you table definitions.

[Joacim Andersson]

I don't get it!
You don't assign a value to bookingid (but you're trying to assign bookingid to a listbox).
Then in your first post you have the following code:

sqlstring = sqlstring & "from booking where booking.bookingid = bookingid"

What value does the sqlstring have for value to start with? And does it end with a space so there is a space before it adds "from booking" to it?