473,219 Members | 1,453 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,219 software developers and data experts.

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 11054
5,501 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
Apr 22 '22 #2

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

Similar topics

by: Josh Strickland | last post by:
I am attempting to create an Access database which uses forms to enter data. The issue I am having is returning the query results from the Stored Procedure back in to the Access Form. ...
by: abc my vclass | last post by:
Is VS2005 debugger let me to see dataset, datatable data as table form? I found if I watch some table or dataset variable is very very hard to see. Is there any good tools or add-ins for debugger...
by: zainis | last post by:
Hello everyone. Anyone can help me to create mdc (multi dimensional clustering) table? I am using iSeries i5 V5R3 and DB2 V8.1. So far i could not find any manual/redbook explaining the...
by: cah1109 | last post by:
my program is supposed to search through an array for a searched name and then post the results in a list box. Now the problem is i need to be able to double click on that results from my search in...
by: rickair7777 | last post by:
Hi, I'm an ex-Notes guy, doing an Access 2007 project. I'm a little weak on Access syntax and functionality. It's not a customer database, but it will be easier to describe it in those terms......
by: leeg | last post by:
Hi all, I am having trouble finding out how to stop a new record showing on my form when there are no records showing in my underlying query Query criteria is populated from a form text box and...
by: prosad | last post by:
hello, Just solved a problem using Javascript onclick, can click on any cell in a dynamic table and it will pass the innerText object value to my form text field. parts of code given below: ...
by: Haroon Rafik | last post by:
I need to print preview data on a form (not a file or documen) using the PrintPreviewDialog componenet. I know how to do it using the PrintForm component, but I need to use the PrintPreviewDialog...
by: Martymcfly | last post by:
Im having some trouble trying to do this. Can somebody please help me..? I have 3 forms: FORM A, FORM B, FORM C. FORM A lets me put data into a couple of text boxes ("Invoice No." & "Days...
by: Reddeppa | last post by:
EXEC master..xp_cmdshell 'BCP "'select * from tmp_ACS_MultiDimensional where cName = 'CH All Workstations''" QUERYOUT ...
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.