Tupacmoche
Registered User.
- Local time
- Today, 18:20
- Joined
- Apr 28, 2008
- Messages
- 291
I have a search button on my main form labeled 'search' it opens a dialoge box that has two unbound
text boxes and a 'run search' button. After entering the two criteria and pressing 'run search' vba
code runs a DoCmd.OpenForm called 'search Results'. This form is a container for a subform that
displays the columns that meet the criteria that were entered. The problem is if, I change what I
entered into the the two unbound text boxes and click on 'Run Search' again the information in the
subform does not refreash. I have added me.refreash, me.requery to the subform but it does not work.
The data source for the subform is a query with this where clause:
WHERE (((dbo_tblTransmittalInfo.GiftID) Like "*" & [Forms]![FrmSearch]![TxtTransmittalNo] & "*") AND
((dbo_tblTransmittalInfo.DonorName) Like "*" & [Forms]![FrmSearch]![TxtDonorName] & "*"));
It only works the first time, I enter text into the unbound text boxes and open the form after that
nothing. Can anyone see what, I'm missing?
text boxes and a 'run search' button. After entering the two criteria and pressing 'run search' vba
code runs a DoCmd.OpenForm called 'search Results'. This form is a container for a subform that
displays the columns that meet the criteria that were entered. The problem is if, I change what I
entered into the the two unbound text boxes and click on 'Run Search' again the information in the
subform does not refreash. I have added me.refreash, me.requery to the subform but it does not work.
The data source for the subform is a query with this where clause:
WHERE (((dbo_tblTransmittalInfo.GiftID) Like "*" & [Forms]![FrmSearch]![TxtTransmittalNo] & "*") AND
((dbo_tblTransmittalInfo.DonorName) Like "*" & [Forms]![FrmSearch]![TxtDonorName] & "*"));
It only works the first time, I enter text into the unbound text boxes and open the form after that
nothing. Can anyone see what, I'm missing?