Re: 2 basic questions from a relative beginner (i'll probably have mor

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Fred Boer (fredboer1_at_NOyahooSPAM.com)
Date: 10/31/04 

Date: Sun, 31 Oct 2004 08:39:26 -0500

Dear FR:

1. That is correct, although some queries that combine multiple
tables/queries can be non-updateable...
2. Setting a default value for a control means that when a *new* record is
created the control will be given that value. It doesn't affect existing
records. I'm not sure, but does this explain the situation? I suppose it
might also be that you might be running into the non-updateable situation as
mentioned above.

HTH
Fred Boer

"FR" <nospam@aol.com> wrote in message
news:FBFB44C7-4492-4207-9660-B320A993BC52@microsoft.com...
> 1. As I understand it, a form can be based either on a single table
> (permitting controls bound to that table's fields only) or on a query
> combining multple tables/queries and allowing controls to be bound to any
of
> them. Is this correct, not counting VBA coding?
>
> 2. I find that a default value specified in the table will show up on the
> form if it is based on the table directly, but not if it is based on a
query.
> How can a form contain controls bound to different tables and still
display
> the default value?
>
> 3. Thanks very much for any enlightenment.
>
> FR

Relevant Pages

  • Refreshing tab control
    ... I have a form with combo box and multi page tab control with many ... controls bound to my query. ... Query is based on value chosen from combo ... How can I force controls to requery if user choose different ...
    (microsoft.public.access.forms)
  • RE: Checking for null fields before running query
    ... I could use that sub and modify it so that it checks for Null in the ... return at least one record when all 3 controls have values. ... 3 cbo boxes, 2 buttons, 12 txt fields. ... the cboboxes provide parameters for a query, and also criteria for 12 DSum ...
    (microsoft.public.access.modulesdaovba)
  • Re: Check for Existing Else go to New
    ... query too. ... sfmProdOp controls are as follows: ... Private Sub SaveIfNew() ... Or IsNullThen Exit Sub ...
    (microsoft.public.access.formscoding)
  • Re: is there a non-data entry mode?
    ... The query I"m referring to is an Access query, ... Defines a variable called strFilter where you'll build an SQL filter ... The controls on the form displaying the data fields that you wish the ...
    (microsoft.public.access.forms)
  • Re: Need Help on Lookup Fields
    ... the Patient Care dBase. ... > Property to the name of this query (as long as the autolookup query has the ... When you create new controls, ... all you have to do when creating a new appointment is to ...
    (microsoft.public.access.forms)