Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 48
Search took 0.16 seconds.
Search: Posts Made By: ngsabath93
Forum: Forms 08-05-2014, 06:47 AM
Replies: 35
Views: 2,286
Posted By ngsabath93
Re: Sync Two related subforms

Also, is it possible to make the devault value on the homepage blank? Thanks!!
Forum: Forms 08-04-2014, 05:59 AM
Replies: 35
Views: 2,286
Posted By ngsabath93
Re: Sync Two related subforms

I made it unbound, and it is still doing this :(
Forum: Forms 08-01-2014, 06:22 AM
Replies: 35
Views: 2,286
Posted By ngsabath93
Re: Sync Two related subforms

Once you enter a new ID into the Client form, I have to click the close button twice for it to actually close
Forum: Forms 07-31-2014, 06:42 AM
Replies: 35
Views: 2,286
Posted By ngsabath93
Re: Sync Two related subforms

55053


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!!
Forum: Forms 07-31-2014, 06:26 AM
Replies: 35
Views: 2,286
Posted By ngsabath93
Re: Sync Two related subforms

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?
Forum: Forms 07-31-2014, 05:12 AM
Replies: 35
Views: 2,286
Posted By ngsabath93
Re: Sync Two related subforms

The first link. And the ClientID is a number field
Forum: Forms 07-30-2014, 12:09 PM
Replies: 35
Views: 2,286
Posted By ngsabath93
Re: Sync Two related subforms

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...
Forum: Forms 07-30-2014, 11:13 AM
Replies: 35
Views: 2,286
Posted By ngsabath93
Re: Sync Two related subforms

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...
Forum: Forms 07-30-2014, 08:22 AM
Replies: 14
Views: 1,333
Posted By ngsabath93
Re: Requery unbound combobox on mainform

Is there anyone else who can help me?
Forum: Forms 07-30-2014, 08:09 AM
Replies: 14
Views: 1,333
Posted By ngsabath93
Re: Requery unbound combobox on mainform

55034


Here is an example to explain what my DB looks like.
Forum: Forms 07-30-2014, 08:06 AM
Replies: 14
Views: 1,333
Posted By ngsabath93
Re: Requery unbound combobox on mainform

I alread have a macro for the on click event to open Clientfrm. How do I place the code before it opens the form
Forum: Forms 07-30-2014, 08:02 AM
Replies: 14
Views: 1,333
Posted By ngsabath93
Re: Requery unbound combobox on mainform

i put in on the on-click event of the unbound combobox on the homepage and nothing happened.
Forum: Forms 07-30-2014, 07:46 AM
Replies: 14
Views: 1,333
Posted By ngsabath93
Re: Requery unbound combobox on mainform

Next to this combo box, i have a button I created from the wizard that opens Clientfrm.
Forum: Forms 07-30-2014, 07:43 AM
Replies: 14
Views: 1,333
Posted By ngsabath93
Re: Requery unbound combobox on mainform

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?
Forum: Forms 07-30-2014, 07:30 AM
Replies: 14
Views: 1,333
Posted By ngsabath93
Re: Requery unbound combobox on mainform

WHich Event AND which form's field do I put this in? And does it matter that my combobox is unbound?
Forum: Forms 07-30-2014, 07:11 AM
Replies: 14
Views: 1,333
Posted By ngsabath93
Requery unbound combobox on mainform

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...
Forum: Forms 07-30-2014, 05:27 AM
Replies: 35
Views: 2,286
Posted By ngsabath93
Re: Sync Two related subforms

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...
Forum: Forms 07-29-2014, 01:02 PM
Replies: 35
Views: 2,286
Posted By ngsabath93
Re: Sync Two related subforms

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...
Forum: Forms 07-29-2014, 11:09 AM
Replies: 35
Views: 2,286
Posted By ngsabath93
Re: Sync Two related subforms

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,...
Forum: Forms 07-29-2014, 10:43 AM
Replies: 35
Views: 2,286
Posted By ngsabath93
Re: Sync Two related subforms

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...
Forum: Forms 07-29-2014, 09:22 AM
Replies: 35
Views: 2,286
Posted By ngsabath93
Re: Sync Two related subforms

Thank you so much! That works perfectly!!! I have another quick question. I want a "homepage" where the user can put in the client ID and if it exists, it will open open the Client form and display...
Forum: Forms 07-29-2014, 05:28 AM
Replies: 35
Views: 2,286
Posted By ngsabath93
Re: Sync Two related subforms

55008


Here is a simplified example of what I have
Forum: Forms 07-29-2014, 05:10 AM
Replies: 35
Views: 2,286
Posted By ngsabath93
Re: Sync Two related subforms

how do I do a save a then requery?
Also I do not currently have any code in the on_close event of my form
Forum: Forms 07-28-2014, 12:36 PM
Replies: 35
Views: 2,286
Posted By ngsabath93
Cool Sync Two related subforms

I have a main form with multpile tabs - each tab containing a different subform.

Link Master Field: ClientID (field in Master Form)
Link Child Field: Client ID (field in all subforms)

There...
Forum: Forms 07-28-2014, 08:00 AM
Replies: 7
Views: 886
Posted By ngsabath93
Re: Auto Populate and Edit

The combobox shows all three fields. How do I prevent this and only show InventoryType options?
Showing results 1 to 25 of 48

 
Forum Jump



All times are GMT -8. The time now is 04:04 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World