Query Data in a Form

[wassimdaccache]

How can i run a query using VB code to search a value in ms access form ( subform) the query that is selected isn't related to relationship but it is in the same file . thank u

[maxamis4]

Well First you have to be familar with recordsets and there functionality. Thats step one. I will give you a template to follow but you must take the time to go out and read up on some of this, or else it will never make sense.

dim rst as recordset
dim db as database
dim mysql as string
 
'Set your sql statement here
mysql "SELECT * FROM [YOUR TABLE]" _ 
          & "WHERE([YOUR_VALUE])= '" & searched value & "'"
'Mind you if the variable you are searching is a number you don't need the apostrophy ' if it is a string you need to enclose the apostropy  at both ends
 
Set db = CurrentDb()
Set rs = db.OpenRecordset(mysql, dbOpenDynaset)
 
your_text_box = rs![Value] 'Value being the primary key of the record you are searching for, or any record based on that criteria.
 
set rs = nothing
 
 

this should be a start for you good luck. Research recordsets

[NeoPa]

How can i run a query using VB code to search a value in ms access form ( subform) the query that is selected isn't related to relationship but it is in the same file . thank u

As you have expressed the question - you can't.
Forms are not containers of data but simply enable views of data in recordsets (Tables or Queries).
You should consider rewording your question in such a way as to make sense (FAQ - How to Ask a Question). If help is required to query a particular table, then you need to share some information about that table.

MODERATOR.

[wassimdaccache]

OK I 'll clear my question ... I have a master link form contains a customerID and invoiceID based on INVOICES_TABLE they are primary key. The subform is linked to this 2 primary keys that is based to the PRODUCT_INFO_TABLE. What I need to know is when I add a new product in the subform I want to find the last cost (if exisit) in the PRODUCT_INFO_TABLE that is related to the customerID in the form .


I was working with recordset but the problem is when I use INNER JOIN I won't be able to open the recordset ....


thank you very much for ur help byyyyyyyyyy