Access Library

[AlyKatVandy]

Greetings! I've been playing around in Access trying to make a record of all the books in my library. I've gotten it mostly completed but I'm having trouble with a button in a form. My goal is to be able to click the button and it will pull a random record from my "UnreadAll" query. Any ideas?

 

[arnelgp]

for starter you need to create a random number generator (search the net - vba random generator).
you also need an autonumber to be included in your query.
then you can pull the record from your UnreadAll query by using dlookup or select query, which ever you prefer.

select * from UnreadAll where ID = fnRandom();

dlookup("ColumnToReturn", "UnreadAll", "ID = " & fnRandom()

 

[theDBguy]

Hi. Welcome to the forum! Have a look at this. Good luck!