470,632 Members | 1,328 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,632 developers. It's quick & easy.

Need Correct Syntax for moving data from a Record in a table to a form

I have found the record in a table, but I need the correct syntax to display it on the form

What I have is the Forms!frmBadWater!Vaults = rst!Vaults

I have tried for days old Access 1.0 Program stopped worked with last Microsoft Update

Any help would be appreciated


Apr 22 '22 #1
1 10474
5,444 Expert Mod 4TB
Hello, Zinenagetto - Welcome to Bytes!

I am amazed that your Access1.0 program was still operational as it was released in 1992 - several Win-OS and updates since then that should have taken it down hard long before now - none of the current versions of Access will even open a DBS file that old!

Your form should be tied to the data source, either from a query or table - thus, you really shouldn't need any VBA for simple returns.
However, if you are running VBA to build the query then you would set the form's record-source property to the returned record-set and then the controls, under the data tab, would have their control source set to the corresponding fields of the returned record-set.
Might be MUCH easier to setup a parameter based query that returns records based upon user entry, either via form control or direct prompt from the query itself (depending on what type of interaction you want with the end user, I prefer the form based as I can customize the prompt given to the user).

If you can give us a bit more information about what you are trying to do, and what version of Access/Office you are currently using, we can help you a bit more as, on first reading anyway, it sounds like you're trying to use a cannon to kill a mosquito
4 Weeks Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by zainis | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.