Text Box Refresh

[eckert1961]

Hello,

I have a small anoying problem that I'm hoping someone can help resolve.

On my main form I have a text box that shows the current number of members that are in the database. The default count is for all members whether they are active or inactive. On this same form I have a list box that I select whether I want to display active, inactive or all. When I select Yes, for example, the text box doesn't display the current count until I either move off the current record or I go to the Records menu and select Refresh.

I have the following in the control source of the text box.

="(" & Dynaset.RecordCount & " " & "Members Found)"

In the After Update event of both the text box and the list box I have added a requery statement.

Text Box:

Me.Requery

List Box:

Text96.requery

I've searched through this forum and all indications are that this should work. Any ideas anyone? Thanks in advance.

Regards,
Chris

 

[eckert1961]

Success

I was able to solve this issue by using the Count function. Here is the correct control source entry.

="(" & Count(*) & " " & "Members Found)"

Regards,
Chris

 

[wkalo]

hi
I Had The SAme Problem But What Happened Is When VBA Cross The Syntax
Requery I Get A Message Field Has To be Saved First So After Looking Thru I Found That Requery Is The Same as Refreh Table But Requery Did Not Work And Regresh Did And The Syntax Is

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

 

[ghudson]

DoCmd.DoMenuItem commands are as outdated as Access 95.

There is an equivilent DoCmd.RunCommand for all menu options.

DoCmd.RunCommand acCmdRefresh

 

[wkalo]

Thank You Much Appreciated For Updating My Info.......