Search results

I'm setting up a search form for my database. On my input form, i have a combo that's populated with a value list. I want to use the same value list for a combo on my search form. I copied the values from one value list to the other, but if i update one, i want the other to update automatically...

maybe this would work? set column count to 2, with widths of 1";0" and bound to column 2

I'm not 100% on this, but i believe you have to save the record before the new autonumber is recognized. I'm still pretty new at this, but here's what i did: i made a button under the combo to add a new record to the table that the combo is referencing. the button opens a new form that asks...

I think i found the key. I have a main table (table1) , and one field (client) is a lookup from another table (table2). table2 has an index field (autonumber), a name field, an address field, and a phone field. table1 has a lot of fields, but the important one is the client lookup field. the...

i have been searching the forums, but i can't find any discussion about looking up records without using the wizard, everyone just recommends using the wizard. it just seems like there's one little thing i'm missing to make a combobox select a record without using the wizard...........

I've tried comparing all the settings between a combobox that's set to find a record that matches the choice, and one that's just added on its own, and can't find any difference. how is a combobox set to find a record? can it be done manually or is the wizard the only way? not a pressing...

That's much nicer. I changed it and it works..... the other code was the best i could find. i think that's even what the help file recommended using......

on a form, i'd like to be able to choose a record (and auto populate the rest of the form) by either project name or enquiry number. i can put in a combo box for one and have it fill in the other, as long as it's a text box. if they're both combos that search for records, i can use either one...

Thanks a lot. The code on its own produced a key violation. i'll try to explain why for future readers. in my main form, in the before_insert event, i put a code to create a new enquiry number (E7603, E7617, etc) by adding one to the max. I placed the code given to me by Wayne right after that...

My main form is used to create new records in the 'input' table. there's an autonumber primary key, and then there's an enquiry_number field (syntax: E67xx). A secondary table tracks contact with clients, and the record to edit in the contact log is selected from a combo box. what i'd like is...

I ended up doing it a slightly different way. i was hoping to have both client and contact subforms on a main input form. some clients have different contacts for different projects, so i need to keep them separate (i think). i had forms working for both clients and contacts that updated all...

I'm still working on the same database, and i still can't get my subforms to work. I have a table that includes client company details: name, address, phone, and fax. it has a client_id field primary key. i have a table that includes contact details: name, phone, email, contact_id primary key...

I'm starting with all empty tables that will be populated as inquiries are processed. I need to insert new records into each table as required, as well as reference old records if applicable. does this make it clearer?

I'm a newbie. i've been browsing the forum for a while now and it's been really helpful, but i can't quite get around what i'm trying to do now without asking specific questions. This seems like it's a pretty basic problem for access: I have a table (Client_info) that has a clients' names...