Search results for query: *

So how can I create the filter?

Hello! I have a large database with multiple tables. There a two central forms, both of which contain multiple subforms. One form (EDIT) has a disabled txtID as well as a tab control with multiple tabs (i.e. "Names," "Contact Info," "Address" etc). Within each...

I have a form containing a subform. I would like to be able to press a search button...a small data entry form opens up...type in the name I would like to locate...press find...and that record to open up based on the input. However, some names are duplicated but have different information...

I would love to see that! You can email the details to me or I'll look for your post next week... Thanks Melissa, Jeremy and C!

Bummer. So there is NO other way I can go about doing this?

Please help :) I have a table where the primary key is an autonumber. Multiple records within the table have been deleted and I would like to get rid of those empty spots (so that the deleted record's following record will take on that number and all following records' PKs will drop by 1)...

Yes, the query is for that single record. However, I'm trying to figure out a way I can enter multiple pieces of data for that specific record, into the subform table. In my current setup, I type in a name...press tab...a new row is displayed...I type in an additional name for that...

Is there a way I can create a subform that allows me to enter multiple names in a datasheet for one record (the record that is listed on the main form)?

Good idea, however the id still will not transfer from form one to form two. The text box for id in form two shows null, but the record is saving from form one.

I am trying to populate a field in one form based on a field from a previous form. In other words, a specific record has a unique identifier in a text box on form one (an autonumber). When the user presses "Continue," that same number should populate the identifier text box of the...