SQL search results in a datasheet

[BasilM]

Hi everyone,


I have a form that contain two field (A and B) ( the values of the fields will be populated automaticlly in the form load based on other cratiria)

those two field are a key together

I want once I open the form, a subform - datasheet to be populated in that form

can I do this by SQL statement where I can say .. Select all records where ATableFeild =A and BTavleField=B

[June7]

You have a form/subform arrangement where subform records are child records related to main form record? Set the Master/Child links properties of the subform container control. This will synchronize display of associated records.

[BasilM]

I tried to do this
it gives me msg:

can't build links to unbound form!

[June7]

Then what do you mean by 'have a subform'? Why do you have a subform on a main form if they don't have a relationship?
Review http://office.microsoft.com/en-us/ac...010098674.aspx

Want to provide db for analysis? Follow instructions at bottom of my post.

[BasilM]

thanks a lot for your reply
I wanted these lines ( I found them in the internet) :
strSql = "SELECT * FROM Controls WHERE AssetID='" & AssetID '"
Debug.Print strSql

Me.sbfOrderDetails.Form.RecordSource = strSql



many many thanks for your support

[June7]

Well, that looks like good example code but not really much info to work with. What happens when you run it? Are those your control and field names? Is AssetID a number or text value?

[BasilM]

yes these are field names
AssetID is a text value

when I run it it works fine
only one small issue
I can't select certine fields in the subform
meaning : when I select A,B,C
it shows me the coulms but empty !

do you have any idea?
I mean can I invisible some coulmns?!

[June7]

Too much unknown. Provide db for analysis. Follow instructions at bottom of my post.