Preparing linked form for use.

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
R

Robin Chapple

I have a membership database where new members register on a website
and I download a CSV so that I can work on the data.

I have a subform linked by MemberID that keeps subsidiary information
for my use. Several of the fields on the subform are yes/no fields.
When I have a new member the sub form has no data and the yes.no
fields are greyed out.

Currently I tick the first field and then untick it to have the yes/no
fields active. This is obviously archaic and there must be a better
way. An important field is [DateWecomed] which needs to be populated
when I open the new member record for the first time. I believe that
if I had code to populate that field the yes/no boxes would be active.

Your suggestions are welcome.

Many thanks,

Robin Chapple
 
My earlier reply was not comprehensive.

Using "Welcomed" as a default value, which is acceptable, leaves the
yes/no fields greyed out. This is the problem. Clicking one yes/no
field makes all the yes/no fields lose their greyed out status.
 
Now I have read your message better. You used "values' in the plural.

I have set a default on all Yes/No fields. All is well.

Many thanks.
 
My subform is [subfrmPending] and the "Welcomed" field is [dayte]

I have tried this in the main form "On Current" event, to move the
focus:

DoCmd.GoToControl "Me!subfrmPending.Form.Dayte"

and I get an error message that the field does not exist.
 
All is not well. The sub form presents itself on the main form but
when I close the data is lost.
 
Back
Top