Re: saving information into a tables

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Wed, 27 Dec 2006 17:30:01 -0800, GlobalTek
<GlobalTek@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I may be wrong but to bound a form to a table without saving you need to have
a combo-box. In my form I have a Text Box with a Default Value and I`m unable
to be able to save the information inside the table ... What other solution
can we use for that ???

Ummm...

You are in fact wrong.

It's perfectly possible to have a bound form without a combo box, or
an unbound form with a combo box. I have NO trace of an idea what you
mean by "bound a form to a table without saving" though.

Having a Default Value on an unbound textbox does exactly NOTHING
unless you have VBA code to open a Recordset based on a table, and
explicitly populate the Recordset with the value from the form - a
much more complex process than simply using a bound form!

John W. Vinson[MVP]
.

Relevant Pages

  • Re: ADO Recordset Cache
    ... >ADO) who was also having problems with getting to grips ... >> and then destroy the recordset within the same Sub ... >> haven't yet produced the effect of moving back and forth ... >> navigation button on a bound form. ...
    (microsoft.public.access.formscoding)
  • Re: Form bound to disconnected ADO recordset and UpdateBatch
    ... correctly that you been able to implement a bound form to a disconnected ADO ... Private Sub Form_Unload ... I would be VERY interested in any code that allows for an updateable Access ... form to be bound to a disconnected recordset. ...
    (microsoft.public.access.formscoding)
  • Re: ADO Recordset Cache
    ... ADO) who was also having problems with getting to grips with this. ... > All of the ADO routines I have written create a recordset ... > haven't yet produced the effect of moving back and forth ... > navigation button on a bound form. ...
    (microsoft.public.access.formscoding)
  • Re: ADO - recordset navigation with code
    ... recordset to the forms module. ... with ADO, it is just Move. ... aware that if you make changes to a field in a bound form, ... > I have set up buttons on my unbound form for MoveNext, ...
    (microsoft.public.access.formscoding)
  • Re: MDB to ADP/SQL
    ... Why are you trying to edit the recordset of a bound form instead of changing ... >I want to use the following VBA code form and Access MDB in an Access ADP. ... > Private Sub Form_Current ...
    (microsoft.public.access.adp.sqlserver)