Default Value Field

  • Thread starter Thread starter Buddy
  • Start date Start date
B

Buddy

New to this, please help...

I have two tables:

Inventory
Default_Year

I have two forms:
Inventory
Default_Year

The Default_Year table only has one field and that is 'Year'. The form just
updates the entry, it is not a list of years, just a single entry that gets
updated.
What I am trying to do is when I open my Inventory form to enter a new item
into the Inventory table I would like the 'Year' to automatically pick up
the 'Default Year' tables entry of 'Year', while at the same time allowing
the user to over-ride that default if needed. Does this make any sense and
can it be done?

Thanks for any future help.
 
Hi:

In the Invnetory form place the "Default Year" as a subform and allow user
to update.

Regards,

Naresh Nichani
Microsoft Access MVP
 
test...
Naresh Nichani MVP said:
Hi:

In the Invnetory form place the "Default Year" as a subform and allow user
to update.

Regards,

Naresh Nichani
Microsoft Access MVP
Click to expand...
 
why is it when i try and send my database over it doesn't show up in the
group?

am i doing something wrong?
 
I would imagine the newsgroup blocks attachments/MDB files.
However i am not sure, im not a regular here.

The simplest way to do what you stated is as Naresh said.
Create a sub form of the Default_Year table.

Regards

--
GH
MCSE

www.bradflack.com

Please remove ANTI and SPAM from my
email address before sending me an email.
 
why is it when i try and send my database over it doesn't show up in the
group?

am i doing something wrong?
Click to expand...

The newsgroup blocks any attachments over a certain size (to block
viruses, mainly - we got a HUGE rash of virus attachments last Fall).

Posting binaries is frowned upon. If you can't describe your problem
in words, ASK if someone is willing to accept a database by email
(*DON'T* send it unsolicited; if you send me one I'll send a
consulting invoice in reply, with any work on the database contingent
upon payment). Almost all problems can be solved with text only if
you're able to explain the problem clearly.
 
Back
Top