A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Combo box, form, Sub-form interaction



 
 
Thread Tools Display Modes
  #1  
Old October 28th, 2005, 07:42 AM
Chris W via AccessMonster.com
external usenet poster
 
Posts: n/a
Default Combo box, form, Sub-form interaction

Hi

I have a form “Fob File” with a combo box for client, bound column client id
and client name displayed. In the Job File Form is a sub-form client, this is
essential a data entry screen for the client table. In the circumstances were
the client already exists I want the user to be able to select them from the
combo box on the Job File form and the information regarding the client be
displayed on the Client Sub form and when the combo box is not displaying any
data i.e. it is a new client the client sub-form should default to a new
record so that the user can simply enter the client information on that form
with having to exit and enter via another form.

Currently I have the combo box working and the sub-form working so that they
can enter new data or scroll through previous/existing clients. However I can
not get them to interact. If any one could hep I would really appreciate it

THanks


--
Message posted via http://www.accessmonster.com
  #2  
Old October 28th, 2005, 01:10 PM
Duane Hookom
external usenet poster
 
Posts: n/a
Default Combo box, form, Sub-form interaction

What do you mean by "interact"? Do you have the Link Master/Child properties
of the subform set? If so, what are their values?

--
Duane Hookom
MS Access MVP


"Chris W via AccessMonster.com" u12677@uwe wrote in message
news:568050a2197e5@uwe...
Hi

I have a form “Fob File” with a combo box for client, bound column client
id
and client name displayed. In the Job File Form is a sub-form client, this
is
essential a data entry screen for the client table. In the circumstances
were
the client already exists I want the user to be able to select them from
the
combo box on the Job File form and the information regarding the client be
displayed on the Client Sub form and when the combo box is not displaying
any
data i.e. it is a new client the client sub-form should default to a new
record so that the user can simply enter the client information on that
form
with having to exit and enter via another form.

Currently I have the combo box working and the sub-form working so that
they
can enter new data or scroll through previous/existing clients. However I
can
not get them to interact. If any one could hep I would really appreciate
it

THanks


--
Message posted via http://www.accessmonster.com



  #3  
Old November 1st, 2005, 10:42 PM
Chris W via AccessMonster.com
external usenet poster
 
Posts: n/a
Default Combo box, form, Sub-form interaction

Hi Duane thanks for your reply

Sorry about the late reply I have had a few days off from work.

By interact I mean that I want the client sub-form to react when the client
is chosen in the combo box. And when the client combo box is blank the sub-
form should allow the entry of a new client, when a client is chosen on the
client combo box the client sub-form should display the chosen client’s
details.


Duane Hookom wrote:
What do you mean by "interact"? Do you have the Link Master/Child properties
of the subform set? If so, what are their values?

Hi

[quoted text clipped - 22 lines]

THanks



--
Message posted via http://www.accessmonster.com
  #4  
Old November 1st, 2005, 10:48 PM
Chris W via AccessMonster.com
external usenet poster
 
Posts: n/a
Default Combo box, form, Sub-form interaction

Got it mate, I tried the master child link and it works great thanks for your
help


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200511/1
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Move feild entries from form to form using global variables JackCGW General Discussion 11 November 14th, 2005 06:22 AM
Tell if Form is a Dialog Alex Using Forms 7 August 30th, 2005 06:22 PM
Access combo box-show name, not ID, in table? write on New Users 30 April 30th, 2005 09:11 PM
Requerying a pop up form to display in the main form Jennifer P Using Forms 13 April 5th, 2005 06:59 PM
Dates in a listbox connected to a form... RusCat Using Forms 13 November 25th, 2004 03:31 AM


All times are GMT +1. The time now is 12:01 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.