How to populate a field with a variable or another way around my problem

[joeydeck]

Hello all,


I am creating a database project and i have run into a problem at which my knowledge is limited. I have created log in form which uses a 'User Table' to authenticate a password. This then Brings a Navigation form.
I then want each user to be able to add their own product into 'Product_Frm' which will go into into a 'Products_Tbl'. This will then filter down to each Members Id. The problem I am having is their will be 2 key fields 'Product Id' and 'Member Id'. How can i get this to work?

I have created a global variable which stores the username when they log in called 'strUsername', can this be automatically added in to the 'Member' field on the 'Products_frm' and i was thinking of filtering this to show only the User who is logged in Products.

If there is a better way to go around this i would be very grateful,

Thanks
Joe

[R_Badger]

The easiest way is to create a new module and in it put simply:

Public Function Username()
Username=strUsername
End Function

then in your default value for your favored field "= username()" that should then place the desired string in the field as default for new records.

Although your approach could be used, i would strongly recommend normalizing as opposed to using strings in such a case.

[joeydeck]

Thanks R_Badger, this seems like a good way around it but when i try to add it as the default value it states 'Unknown Function 'Username' in validation expression,??

Joe

[joeydeck]

Scratch that, its all sorted now,

Thanks for your help!

Joe