Open form to specific record

[jake7363]

Hi,
It has been a few years since I used Access, so I'm asking your patience..

I am trying to open a columnar form from a tabular form (continuous) using a command button. I used the button wizard, but when I tried to match the key field ("id") in each form, it only showed fields on the right side of the wizard and not the left. This effect was the same when I tried the reverse of opening the tabular with the columnar.

Regardless of the fact that there is only one table (and it seemed dumb), I still checked to make sure the table was inserted in the form properties in each. Likewise, I verified that the "id" field in the table was designated as Key.

I closed the db and reopened each time I made a change, but the results were the same. What am I missing??

Thanks in advance,
Jake

 

[Alansidman]

Is this helpful?

http://www.datapigtechnologies.com/flashfiles/buildcustomfilter.html

 

[jake7363]

Unfortunately, this is not what I am looking for; I don't want to use a combo box, but a button.

Thanks anyway.

 

[vbaInet]

Something like this?

http://baldyweb.com/wherecondition.htm

 

[jake7363]

As best I can tell from my rusty vba, that looks like it. But I am wondering why the wizard is not showing the fields in the form I am making the selection from. I would be less surprised if it didn't show the form to be opened, but this is the resident form on which I am currently working. Any ideas?

 

[vbaInet]

I don't use the wizard much. Let me see your db.

 

[jake7363]

Unfortunately, the db contains personal, confidential, financial information - so that is a problem.

What I can say is that there is only one table and the field I am trying to match is an ID field (autonumber) as long integer (Access default). That is the key field. What is the oddest part is that the wizard shows the fields from the form I'm accessing, but not the form I am working in.

Could this be a glitch in the app (although I think I would not be the first to find it)?

 

[vbaInet]

Obviously I don't require confidential data. Some dummy data will do with just the relevant tables, forms, queries in the db.

 

[jake7363]

I did find an answer. It turns out, there are a couple of issues with the wizard. First of all, it is not showing the fields in the resident (working) form. Secondly, when it did work (I guess it did for someone at some point), it was leaving out one "=" from the code.

Ultimately, from a couple of other forums, neither provided a total answer, but each provided part of the answer and I wound up with something pretty close to what you suggested with the Baldy site..the difference (don't know why) is that Me!ControlName worked, while Me.ControlName didn't. Could be typo or something...all I know is that I have it working.

Thanks for your help!
Cheers,
Jake

 

[vbaInet]

The only time I've seen the wizard not working as expected is when a form is corrupt.

The problem you had with the dot and exclamation mark has something to do with the name of your control and the name of the field it is bound to.

Glad you got it working.