Recent content by utdel

try adding this to your code: rs.FindFirst "[Employee ID] = " Str(Nz(Me![Combo14], 0)) then on the column width for the combo box set them to 0";1" 0=no width for key so it won't display then adjust the employee name. and if nothing else use the combo wizard to readd the combo box. it should...

thanks DBL it worked. again thanks to all who replyed. hope to return the favor one of these days. thats if i get as good as you guys.

ok i've looked through the archives and still don't get it. here is my problem. I have a main form which is linked to a subform. on the main form i have a combo box that list players name. when a players name is select the associated player cards are displayed in the subform(main data only)...

Ok Guys need some help. I'm almost finish with a project but I'm stuck with a combo_box problem. How can I set the combo_box to display the first record in the recordset(actually a query) when the form is open? Currently when the form is open it is blank until the user presses the down arrow...

Thanks to everyone who replied!!! I think I got enough info from BukHix's code to do what I need to do. Special thanks to you BukHix, looks like its going to work for me. Later guys...

No this will not be redundant data. I need to create two different work order records per customer request. The new records will contain customer ids and other data(default start and end dates based on the main forms entry date) from the main form. All three tables are linked. I don't want the...

I have a form where I am adding a record to a table. This works fine but I also need to add some of the form's data to another table. At what point(event) should I add this new record? Also would I need to open a recordset for the other table and manually add the record via code? (short example...

Need help you Access Gurus, I need to find a way to calculate a previous date base on a given date and the number of months to go back to. Example: what date was it 2 months ago as of 11/12/2001? It there an Access function to do this or do I need to write some code? Either way if anyone has...

Need help you Access Gurus, I need to find a way to calculate a previous date base on a given date and the number of months to go back to. Example: what date was it 2 months ago as of 11/12/2001? It there an Access function to do this or do I need to write some code? Either way if anyone has...