Automatic Fill in the ChruchID text control

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
F

Frank Situmorang

Hello,

How can I make it that everytime I add recorrd and starting typing Firstname
Txt Control in the form, there is an automatic fill to ChruchID text conntrol
that take data from Default table field chruchID.

Thanks in Advance
 
Barret:

Since the software will be used by many churches of the same denomination,
so what I intended to do is to have the text control combo box in the
memberform, and not to let them change the chruchID that I gave to them.

Giwever since the same software willb e used to consolidate/combined all
members from all chruches in the Regional chruch office, so there is still
chance to see it in combo in the upper level office, but not in the chruch
level.

So I am interested to do the macro you said, but I do not know how to do it

Thanks in advance for your help.
 
Hello,

How can I make it that everytime I add recorrd and starting typing Firstname
Txt Control in the form, there is an automatic fill to ChruchID text conntrol
that take data from Default table field chruchID.

Thanks in Advance
Click to expand...

If each Church has its own copy of the database (as it surely must, since you
can't effectively link Access databases over a Wide Area Network), just set
the DefaultValue property of each ChurchID control to that church's ID before
you distribute the database.
 
The problem I see is making sure that Church X gets the file with Church X
set as the ID.
If it is hard coded anyplace then *every* time you make a change you have to
send out the right form to the right church.
This can be solved by using a common method.
Have a ChurchInformation table and a form to go with it.
The end user fills in the ChurchID, Church Name, names, addresses, phone
numbers, etc, etc.
 
The problem I see is making sure that Church X gets the file with Church X
set as the ID.
If it is hard coded anyplace then *every* time you make a change you have to
send out the right form to the right church.
This can be solved by using a common method.
Have a ChurchInformation table and a form to go with it.
The end user fills in the ChurchID, Church Name, names, addresses, phone
numbers, etc, etc.
Click to expand...

Excellent suggestion... much better than mine!
 
Back
Top