Search results

Also, is it possible to make the devault value on the homepage blank? Thanks!!

I made it unbound, and it is still doing this :(

Once you enter a new ID into the Client form, I have to click the close button twice for it to actually close

I just attached the database, I hope that is ok. Its the same as before. Thank you again for all your help! You're truly a life saver!!

ok I figured it out. However once the form opens and I fill out the blank form and close it, he form closes and then reopens diplaying all the information I just typed in. Is this normal?

The first link. And the ClientID is a number field

I tried using the first link. Can I use this if My ClientID is a number field? Also On the homepage...how should I make this combobox? SHould I click add existing field (then choose ClientID from the table of CLientfrm)? or should I make a whole new underlying table for homepage and add a new...

When I try to type a new ID into the field on "Homepage" it gets a messgae: "The text you entered isn't an item in the list. Select an item from the lsit, or enter text that matched one of the listed items. It doesnt give me the option to open a blank ClientFrm

Is there anyone else who can help me?

Here is an example to explain what my DB looks like.

I alread have a macro for the on click event to open Clientfrm. How do I place the code before it opens the form

i put in on the on-click event of the unbound combobox on the homepage and nothing happened.

Next to this combo box, i have a button I created from the wizard that opens Clientfrm.

IM sorry I am a beginner at VBA. Where do I put this code?? ok I am in design view of "Homepage" and on the property sheet of the unboound combobox. I am at the event tab. Where do i place this code?

WHich Event AND which form's field do I put this in? And does it matter that my combobox is unbound?

I have a form "Clientfrm" with a field, "ClientID". I have another form, "HomePage", with an unbound combobox with rowsource "ClientID" from Clientfrm. Along with that, I have an Open Form button that pops up "Clientfrm" to display existing data if an existing ClientID is typed. SITUATION: A...

ok I slightly changed my mind. I am ok with a completely blank form popping up if a nonexistant ClientID is typed. However, I want the combobox to requery (or refresh?) itself so that if I exit out of the pop up Client Form, the typed ID will show up in the dropdown menu of the homepage field...

I guess ideally, I want there to be a homepage. And when the user types the ID, it will either take them to an existing form or a brand new one. On the new blank one, all fields will be blank except the Client ID, which will be filled in with the ID typed in from the main page. Does that make...

That is not the only thing on that table. There are about 7 other fields in the main table along with clientID. for example, one field is: Payment DueDate. I did this because on one of the tabs, there is a subform where all the obligors are entered (continous form, like above), but the Payment...

Yeah, for the most part. But the form is made up of about 10 tabs with ten subforms. 5 of the subforms have the same underlying table (hence what I asked about), but the other 5 subforms each have 5 different underlying tables. However, each table has the foreign key, ClientID. In relationships...