Search results

Thanks, it works. And so simple! How do I set the OP to "Solved"? Or is this something the admins do?

Here's what I'm trying to do: I have an unbound login form that looks up credentials in tbl_users. So far, so good, thank you Google, this forum and copy-paste. The match is made on user name and password, but I also want to retrieve the userid and put it in a textbox on the login form. Here's...

Good to know. I won't need to pass the modelid on to many records nor is my form set to data entry, so I'll try to get your code working.

Would that require me to base the form on the table/query of which modelid is the PK? The reason I'm asking is that I want to enter the modelid as an FK in a query based on another table. Also, what does ... mean in your code? Sorry to ask but being a VBA noob sometimes makes it hard for me to...

Thank you for the pointer, Paul. I searched the forum again and found the solution. Since I can't post a link yet (too few posts), here's the code for anyone stumbling on this thread:

My noob-answer would be "yes and no": The reviewmodelid exists but it gets inserted in a new record of the query based on tbl_reviews. So in tbl_reviews, reviewid is the PK, while [reviewmodelid] is the FK. When I used the combo, it would insert the modelreviewid FK, even if the reviewid PK...

I did as you suggested, and frm_review opens, but [reviewmodelid] remains empty. Do I need to ditch the original combo (still on the form, tied to [reviewmodelid]? ETA: deleted the combo, still no go :-( Another edit: I notice the control source of the reviewmodelid field on the form is...

Absolute VBA noob here. I've been searching the net for days but the answers confuse me more than they help. I need a good VBA book... Anyways, I have a search form based on a query that is based on tbl_models. When the model is found, you double-click on it in a listbox and a data entry form...

Thanks for the suggestions Doc_Man. I've seen similar suggestions on my internet searches but I am not yet skilled enough in VBA to pull them off. Right now, I'm still stuck at subroutines and will probably take a stab at functions next. Some background info on the purpose of my project: I want...

I had done that, but that didn't seem to answer my questions. Still, I took your suggestion and while creating a login form, some things dawned on me that I wanted to share in case another noob stumbles onto this thread: 1. To tie their actions to their user names: this is not a security issue...

Looking for advice on where to start educating myself on the following matter. My project consists of a Postgresql back-end/Access 2016 front-end combination. For the time being, the two connect through a system DSN ODBC connection. I have come to a point where I need to identify users for two...

Hello all, My real name is Richard and I just registered on this forum. I have worked with Access in the late 1990s, when I created a customer order tracking database (with Access 97). I live in the Netherlands with a wife and two teenagers. I'm on the right side of 50 (I'll let you be the...