hi every body

[mahdiswaidan11]

hi iam new here if some one can help me
iam made a query ...SELECT VisitD.VFirst ,VisitD.Valenter,VisitD.Valexit
FROM VistD
WHERE VisitID.Valenter < Text0.Value

this query is said to be opend in a subform in my form where instead of giving the value of the parameter in the popup box i want to give directly from a textbox which i will select from it a short date wheneve i press a buttom what i should do

 

[apr pillai]

Use the [Text0] reference correctly in the Query as below:

SELECT VisitD.VFirst ,VisitD.Valenter,VisitD.Valexit
FROM VistD
WHERE VisitID.Valenter < Forms!YourFormName!Text0;

You may use: Me.Refresh statement in the Button Click event procedure to refresh the Query result when the value is changed in the Text0 control.

 

[missinglinq]

I'm not sure the problem is in your reference to Text0 on the form, although I'd have used Me.Text0.

SELECT VisitD.VFirst ,VisitD.Valenter,VisitD.Valexit
FROM VistD
WHERE VisitID.Valenter < Text0.Value

It would appear that you're referencing three different Tables, VisitD,VistD and VisitID, and I'm not sure that this is the fact here. I'd check the spelling here, first off.

Linq ;0)>

 

[boblarson]

You may use: Me.Refresh statement in the Button Click event procedure to refresh the Query result when the value is changed in the Text0 control.

Not a good use of Refresh. Use Me.Requery instead as refresh does not account for added or deleted records by other users. It only refreshes the existing records that have been pulled in case there were changes to those records. If any were added or deleted you will not get notification or get those records in or out of your form.