Hi, I'm an access rookie and I'm trying to make a form where the user selects the userId from a combo box. Then
a query or whatever has to let the user know that certain works are pending.
For example, I have a start date and a complete date. and I'd know a pending report if the complete date is empty.
Also, I want to print out a report that has a full name instead of the userId.

Any help would be greatly appreciated.
Thanks .:

Have you created the query that has all the fields you want to check?

Set your query to the criteria:

Form!SearchFormName![comboboxname]

On your search form, put a command button that runs this query. Hit it after you make your combo choice (you could make this automatic on the AfterUpdate event of your combo too).

The query will return all records that equal your [CompletionDate] combo. If there is none, you will get a blank spreadsheet.

See if you get that running before we move on.

hi jwindon,
please excuse me for my ignorance cause i havnen't a clue how to do what you have suggested. Can you please provide me with an example similar to this problem so that i can understand more clearly.
thanks in advance
devx .:

OK I will help, but I need to some more info. What is the record source for your form, meaning What is the table your form is based off of? Of that table, what is the field name you want to check?

I threw a quick demo together. Shall I email it?

sure, please email me the examples.

this is what my table fields looks like
*********************************************tblUs er:
userID text(k) (eg. tiommi)
userName text (eg. Tony Iommi)
*********************************************
tblInfo
acctNum autoNumber(k)
userID text
startDate date/time
endDate date/time
custName text
salesPerson text
Reason memo
city text
*********************************************
i have 1-many relationship between tblUser and tblInfo.
I think my record source for my frmUser would be tblInfo here.
My whole purpose of this database is to keep track of the pending forms the user hasn't finish. If the user finishes the task in a day then it's super cause i'll have both startDate and endDate in my database and the report is complete.
But in case they don't finish the work in a day and usually it takes more than a day to complete, then I would like the user to be able to see their pending tasks and finish it off later by completing the endDate field.
Also if I make a report out of frmUser, then is it possible to show their FullName instead of their UserID on the final report.

many many thankx
regards
devx