Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Autofill with a grouping

Status
Not open for further replies.
Emario

Emario

MIS
Aug 6, 2001
39
0
0
US
I have an access database budgeting tool

4 tables
Accounts
Account Types
Transactions
Department

One one form I have an ACCTID field an Account, AcctNumber and AccountType. I want the user to choose the account and automatically fill the AcctNumber. I am able to do this with the me.acctnumber = me.accoountcolumn(0). However in the account type field I don't all the account types returned just the account types in the AccountNumber seried. Thanks in advance happy holiday to the greatest forum out there!
 
Status
Not open for further replies.

Similar threads

atadbitslow
  • Locked
  • Question
comparing fields, one populated with data and one blank 2
Replies
8
Views
136
atadbitslow
atadbitslow
grnzbra
  • Locked
  • Question
Using Access Database Without Having MS Access
Replies
9
Views
291
grnzbra
grnzbra
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
184
TheresAlwaysAWay
TheresAlwaysAWay
EM1107
  • Locked
  • Question
populate a column with time from other column.
Replies
1
Views
62
Andrzejek
Andrzejek
cimoli
  • Locked
  • Question
Best password method with time factor
Replies
3
Views
100
cimoli
cimoli

Part and Inventory Search

Sponsor

Back
Top