TinaF wrote:
On Jun 13, 9:57 am, James <james_no_spam_ple...@yahoo.co.ukwrote:
>>Hi
Unless I've misunderstood you should just be able to enter "OTHERS" as
the default value
Thanks
James
http://www.jamesoleary.co.uk/
On 13 Jun, 15:52, TinaF <tferr...@uiscorp.comwrote:
>>>I want to set a default value in a table called "Quotes" for a field
called "Source."
>>>The "Source" field uses a lookup table called "Source" which looks
like this:
>>>Sourceabbrev Sourcename
BX-MI BUILDERS EXCHANGE MI
BX-OH BUILDERS EXCHANGE OH
CNS-MI CONSTRUCTION NEWS SERVICE MI
DODGE-MI DODGE MI
OTHER OTHER
>>>I want the default to be "OTHER". What do I need to enter in the
"Quotes" "Source" default value line to get this to happen?
>>>I need the exact syntax since I've tried several things and keep
getting syntax or other errors.
>>>Thanks,
Tina
I can't do that because the data type is set to Number. So I'm
assuming it uses the row number. I did not set up this database,
someone else did before I worked here.
Are you saying that the Source field in table Quotes is numeric? And
the SourceTable has no numeric or autonumber fields in it? That seems odd.
Well, if it's using numbers then, look for a quote record with the
Source = Other. I suppose that would be a 4 based on the record list of
the source table you provide. Try 1,2, or 3 if that doesn't work.
I suppose if that's the way it's done you can find some code that
converts the numbers to text and visa versa. Seems like a bunch of work
when one could have used a lookup table. Or perhaps it is using a combo
box to select and the rowsource type (open property sheet of combo,
click Data tab) is ValueList instead of Table/Query. If so, determine
the number associated to the value list.