Re: Programatically Populate a Field?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

In answer to your question:

"Does VBA know to look into the RecordSet of a form for stuff like this?"

the answer is Yes! You don't actually have to have a control on your form
tied to a field to write a value to the underlying RecordSource table.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via http://www.accessmonster.com

.

Relevant Pages

  • RE: open arguments.
    ... Do you use Macros or the VBA (Visual Basic ... Each Access Form may be bound to a Recordset and each Recordset ... do this then you must explicitly reference every object you use or Access ... Dim strFilter As String ...
    (microsoft.public.access.modulesdaovba)
  • Re: Data Changing Issue
    ... In the query, on the field line, I added the above expression. ... *if* you are in VBA. ... the data of your table from a recordset. ... I am running some queries using a form I created and for some ...
    (microsoft.public.access.queries)
  • Re: MS Access 2003 CrossTab Query Question using VBA--Item not fou
    ... VBA code runs & hits the break point the code will stop and the VBA ... Your code only reads the first row of the recordset. ... before running a crosstab ones does not know how many columns will appear and what their name will be..that is the natureof a crosstab. ... going to appear based on parameter criteria fed to an underlying query that a crosstab query is created from. ...
    (microsoft.public.access.queries)
  • Re: Compile ErrorInteracting with Access
    ... I'm relatively new to the VBA areana. ... > | Dim Cnct As String, ... > | Dim Recordset As ADODB.Recordset ... > | Set Connection = New ADODB.Connection ...
    (microsoft.public.excel.programming)
  • Re: EDI export
    ... To put each column in one line you'll have to use VBA & a recordset. ... > export a text file from a query or table. ... > It has to all be in a single column. ...
    (microsoft.public.access.queries)