Expression Help - Pulling a number from a text box.

[MintChipMadness]

I am trying to pull a number from a text box. I listed the expression for the box below. [Current Record] is a number and Count(*) is a number. I couldn't figure out what field gave me the total records so I did a count instead. If I want to pull the value from just the count portion, what expression would do that? Please no VBA. Thank you.

=[CurrentRecord] & " of " & Count(*)

please note the spaces on either side of "of"

[John_G]

What do you want to do with the value resulting from count(*) ? Using it by itself as the source for a textbox works fine, so all you need to do is reference that textbox.

Are you using this in a form or a report?

John

[MintChipMadness]

I can't use a count function in my if statement of a button I created. I created a next record button on a form and when the button reaches the same amount of records as the total records it doesn't go any further. For some reason the macro errors and says I can't use the count function in the statement. I created the text box from my first post on the same form and the work around would be to pull the total from that text box.

[JoeM]

What exactly are you trying to count?
If the number of records in a table or query, then I would use the DCOUNT function. If you leave off the criteria argument, it will return the total record count for that object.
See: http://office.microsoft.com/en-us/ac...001228817.aspx

[John_G]

I'm not sure if the Count(*) will work as you want it to in this situation anyway. It gives you the proper number of records when you first open the form, but as you add more, it is not updated.

All this information is readily available in the record navigation bar at the bottom of the form - is there a reason why you need it on the form, too?

The reason for the error is probably because if you explicitly (code or macro) try to move to the next record when you are already on the last one, it will give you an error.

John

[MintChipMadness]

Dcount worked. I am trying to create the form for people that haven't used access before. Some people won't know to look at the tiny record navigation bar at the bottom.

Out of curiosity, how would I extract the information for the string? I figured out the position of the first space using InStr and added 3 to get to the position of the last space. I then got stuck on finding a function that prints everything after that point. Is there a function that does that?

[MintChipMadness]

got it!!

=Mid([recordtotals],(InStr([recordtotals]," ")+4))