AccessWhenNoSQL
New member
- Local time
- Today, 15:31
- Joined
- Sep 23, 2010
- Messages
- 3
List from Query w/ Set List Item 'Default' from Query
SO I have a form with a list box labeled type...
Type: __________v
Drop down will be from a query on a table returning
TypeA
TypeB
TypeC
I also need a default value in 'Type' from a query on a table where getuser() is used as a where and thw return is type...
field user|type
user1|TypeA
user2|TypeB
user3| TypeC
The "type" needs to be default but the drop down also needs to list the types because type could manually be changed but its for convenience that the default populate on new records...
Can this be done and what is the syntax to have a query return a default value and keep the drop down list values available?
What happens now is the default shows like this when the form is opened:
The Drop Down populates correctly:
I need to have it fill in automatically with the "default type" of the getuser()
Thanks for any help!
SO I have a form with a list box labeled type...
Type: __________v
Drop down will be from a query on a table returning
TypeA
TypeB
TypeC
I also need a default value in 'Type' from a query on a table where getuser() is used as a where and thw return is type...
field user|type
user1|TypeA
user2|TypeB
user3| TypeC
The "type" needs to be default but the drop down also needs to list the types because type could manually be changed but its for convenience that the default populate on new records...
Can this be done and what is the syntax to have a query return a default value and keep the drop down list values available?


What happens now is the default shows like this when the form is opened:

The Drop Down populates correctly:

I need to have it fill in automatically with the "default type" of the getuser()
Thanks for any help!
Last edited: