Help with filtering with Combobox

shall

Um which way did it go?
Local time
Today, 01:02
Joined
Mar 7, 2011
Messages
52
I have a form that I am trying to have a combobox that once an item is selected from it. It will only show items associated with it. I setup the second query but cant seem to get it pull the rest of the info or even get the combobox item to stick please help.

It is attached please help
 

Attachments

Shall

As mentioned in an earlier thread you are more likely to get a response if you can save the DB as 2003 rather than 2007

Brian
 
Shall

As mentioned in an earlier thread you are more likely to get a response if you can save the DB as 2003 rather than 2007

Brian

This is quite true.

This DB has some issues with basic design, I have attached a revamped database based on your data. This should make your question a little more simple as it might not even be needed anymore :)
 

Attachments

i no 2003 is preferred but was unable to do it
 
@Vapid I like what I see but I have been having this issue that on the form view it will not show anything. I can see it in design view any ideas on how to fix?

Did you add any data? I did not add any records other than the lookup tables.

So add a few records and I think your issue might be resolved.

Also make sure you spend some time seeing how I set it up and make sure its what you expect.
 
well whats the point of using the newer versions if you dont take advantage of the upgrades
 
well whats the point of using the newer versions if you dont take advantage of the upgrades

Wait till you start working with multivalue fields, then find out that you need to redesign the entire DB because they dont work as easy as you planned :)
 
yeah i have been there done that. Like queries are uneditable if you use them :)

I was also trying to look at the subform you created in the DB but it only lists it in a box that says Table.tblNotes any way to view the details and properties of that?
 
yeah i have been there done that. Like queries are uneditable if you use them :)

I was also trying to look at the subform you created in the DB but it only lists it in a box that says Table.tblNotes any way to view the details and properties of that?

Thats because its not a form, its a table.

If you want a form you would need to create one, then add it into frmEmployData as a subform.
 
ok another question for the sample you put together I want to be able to setup a search for the frmEmployData. I made the query but how would I attach it to that form and to another i had made that is pretty much a duplicate of the original but with another table called tblAttendance.

I want to be able to search for an employee and get both forms (frmEmployData & frmEmployAtt) to come up with the same employee.

Also want to still be able to add info to the frmEmployData without interfering with the query. I am assuming i could still use a button on a switchboard that would open it with a macro and on add data mode.
 
Last edited:
@vapid I have been looking at the DB you had setup and made a few changes before I start one, but i cant seem to get them to work would you mind taking a look at it and letting me know what I am doing wrong?

For the search form I am trying to get it to search for FName & LName but then to pull up both qryEmployData & qryEmployAtt. Also don't know if the inserted tables in both will also pull employee specific info. Thanks
 

Attachments

@vapid I have been looking at the DB you had setup and made a few changes before I start one, but i cant seem to get them to work would you mind taking a look at it and letting me know what I am doing wrong?

For the search form I am trying to get it to search for FName & LName but then to pull up both qryEmployData & qryEmployAtt. Also don't know if the inserted tables in both will also pull employee specific info. Thanks

The attached file is missing qryEmployData & qryEmployAtt did you send the correct file?
 
Sorry I attached the first version you had done and saved the other in another area this one should have the fields
 

Attachments

Sorry I attached the first version you had done and saved the other in another area this one should have the fields

First thing I see is that your calling forms "qry"

frm = Forms
qry = Queries
tbl = Tables

Doing this will help you later on when you need to select data sources etc.

Why not have your search directly on frm main? I don’t see why it needs to be on another form. Same goes for the add employee option.

I would create a continuous form that has some basic data about the staff members and then add a edit button that will open the form where you can edit data for that staffer you can use something like
Code:
"WHERE [numEmployNum]=" & numEmployNum
. Take a look at the following to get a better idea. Also it shows you how to create a search.


http://allenbrowne.com/AppFindAsUType.html
 
First thing I see is that your calling forms "qry"

frm = Forms
qry = Queries
tbl = Tables

Doing this will help you later on when you need to select data sources etc.

Why not have your search directly on frm main? I don’t see why it needs to be on another form. Same goes for the add employee option.

I would create a continuous form that has some basic data about the staff members and then add a edit button that will open the form where you can edit data for that staffer you can use something like
Code:
"WHERE [numEmployNum]=" & numEmployNum
. Take a look at the following to get a better idea. Also it shows you how to create a search.


[URL="http://allenbrowne.com/AppFindAsUType.html"]http://allenbrowne.com/AppFindAsUType.html[/URL]

I would have named it that but already had one named frmEmployData. I was also looking at doing a seperate search form as i wanted the search to put the info on 2 forms both frmEmployData & frmEmployAtt.

Unfortuantely I dont know much about coding and I am thinking that is what i will probably need to do for the results I want.
 

Users who are viewing this thread

Back
Top Bottom