Opening a popup form

  • Thread starter Thread starter Jen
  • Start date Start date
J

Jen

I'm having trouble with what should be a simple thing.

I have a primary key that's made up of three fields
(BookNumberPre, BookNumber, and BookNumberMod). In my
form, I want to use a button to open a popup form showing
some info for the currently open record. I've put the
following on the button:

DoCmd.OpenForm "BorrowingRecords", , , BookNumberPre = Me!
BookNumberPre And BookNumber = Me!BookNumber And
BookNumberMod = Me!BookNumberMod

But no matter what record is currently selected, it opens
the popup for the first record. Any idea what I'm doing
wrong?
 
Nevermind...I did it another way (by basing my popup on a
query). Works OK.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reading only Certain Numbers from Scanner 3
form opening 1
INSERT SQL with Access 4
main form and popup 1
Popup form 3
Add a new record via a popup form 10
Parent.RecordSource in a popup 4
Filter a popup form 2

Back
Top