General Table/Input Data Question

[Sid]

have a bit of a problem for a small little project i wish to finish and i am
stuck on a minor detail.

Basically this little project has to keep track of receipts

Company Name
Vat Number
Date of Receipt
Amount of Transaction

the easy way of doing it of course is just straight input it into the table
(either directly or via the use of a form to mask the entry into the table in
a pretty way)

I have gone the form route and well i have discovered that i have several
receipts from the same company which means i have to enter the company name
and Vat number over and over again.

which is time consuming as you can imagine

i could create a companies table and have the form pull the info from this
table. BUT if there is a new company i have to go to the company table input
it there and then go to the form to fill out the rest

is there a way (im sure there is.. i just cant get my head around it right
now)

to have the form pull up the company and vat data from a table, if that
particular data does not exist allow you to input it on the spot and then,
let you fill in the rest date and amount of transaction ?

thanks in advance..

Sid

 

[Jeff Boyce]

Sid

Check Access HELP re: NotInList and LimitToList. HELP has syntax and
examples you can adapt.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[De Jager]

have a bit of a problem for a small little project i wish to finish and i
am
stuck on a minor detail.

Basically this little project has to keep track of receipts

Company Name
Vat Number
Date of Receipt
Amount of Transaction

the easy way of doing it of course is just straight input it into the
table
(either directly or via the use of a form to mask the entry into the table
in
a pretty way)

I have gone the form route and well i have discovered that i have several
receipts from the same company which means i have to enter the company
name
and Vat number over and over again.

which is time consuming as you can imagine

i could create a companies table and have the form pull the info from this
table. BUT if there is a new company i have to go to the company table
input
it there and then go to the form to fill out the rest

is there a way (im sure there is.. i just cant get my head around it right
now)

to have the form pull up the company and vat data from a table, if that
particular data does not exist allow you to input it on the spot and then,
let you fill in the rest date and amount of transaction ?

thanks in advance..

Sid

 

[joelgeraldine]

ggggggg<g